SGA Monitor 
This sub-monitor in the SAP/Oracle Database Monitor lets you monitor the System Global Area (SGA).
You choose 
Performance
Statistical Information SGA
Monitor 
in the DBA Cockpit.
You can view history information in this monitor.
Structure
Note
Entries marked “RAC only” are only relevant for Oracle Real Application Cluster (RAC).
SGA
This screen provides basic information about the SGA components.
The Oracle views GV$SGA and GV$SGA_DYNAMIC_FREE_MEMORY supplies the information displayed.
If there are multiple instances, total rows are displayed.
Column
Description
Comp .grp.
SGA component group
Inst Id
RAC only
Instance ID
Instance Name
RAC only
Instance name
Mem. size
Memory size in bytes
SGA (detail)
This tab page provides detailed information about the SGA components.
The Oracle view GV$SGASTAT supplies the information displayed.
Column
Description
Pool
Pool in which the memory of this SGA component name resides
SGA component name
SGA component name
Inst Id
RAC only
Instance ID
Instance Name
RAC only
Instance name
Mem. size
Memory size in bytes
Curr. SGA resize op.
This tab page provides information about current resize operations on the SGA.
The Oracle view GV$SGA_CURRENT_RESIZE_OPS supplies the information displayed.
Full
This view groups the information by component and shows totals for all instances.
Column
Description
Component name
SGA component name
Inst ...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Op. type
Type of operation, grow or shrink
Op. mode
Mode of operation, manual or automatic
Parameter for the resize op.
Parameter used in the resize operation
Parameter value at the start
Parameter value at the start of the operation
Desired param. value
Desired parameter value after the resize
Curr. value
Current value of the parameter
Start time of the operation
Start time of the operation
Start date
Start date of the operation
Upd. time
Last time progress was made for the operation
Upd. date
Last date progress was made for the operation
Sort by Component
This tab page sorts the information by component. There are no instance totals.
This tab page displays the same information as the table above.
Dyn. SGA Components
This tab page displays information about dynamic SGA components. It summarizes information from all completed SGA resize operations since instance startup. All sizes are in bytes.
The Oracle view GV$SGA_DYNAMIC_COMPONENTS supplies the information displayed.
Full
This view groups the information by component and shows totals for all instances.
Column
Description
Component
SGA component name
Inst ...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Curr. value
Current size of the component
Min. size
Minimum size of the component since instance startup
Max. size
Maximum size of the component since instance startup
Operations
Number of operations since instance startup
Last op.
Last completed operation for the component
Last mode
Mode of last completed operation for the component
Start time
Start time of the last completed operation for the component
Op. Date
Start date of the last completed operation for the component
Granul.
Granularity of the last completed operation for the component
Sort by Component
This tab page sorts the information by component. There are no instance totals.
This tab page displays the same information as the table above.
Comp. SGA Resize op.
This tab page displays information about the last 100 completed SGA resize operations (excluding in-progress operations). All sizes are in bytes.
The Oracle view GV$SGA_RESIZE_OPS supplies the information displayed.
Full
This view groups the information by component and shows totals for all instances.
Column
Description
Component name
SGA component name
Inst ...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Op. type
Type of operation, grow or shrink
Op. mode
Mode of operation, manual or automatic
Parameter for the resize op.
Parameter used in the resize operation
Parameter value at the start
Parameter value at the start of the operation
Desired param. value
Desired parameter value after the resize
Real. value after resize
Real parameter value after the resize
Status
Completion status of the operation: normal, cancel, or error
Start Time
Start time of the operation
End Time
End time of the operation
Sort by Component
This tab page sorts the information by component. There are no instance totals.
This tab page displays the same information as the table above.
Cache Advisory stat.
This tab page displays information to predict the number of physical reads for the cache size corresponding to each row.
The Oracle view GV$DB_CACHE_ADVICE supplies the information displayed.
Full
This tab page groups the information by component and shows totals for all instances. It only shows size factor one.
Column
Description
Pool ID
Buffer pool identifier
Pool name
Buffer pool name
Inst ...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Block Size
Block size in bytes for buffers in this pool
Status
Status of the advisory:
ON – currently running
OFF – disabled
Cache (MB)
Cache size for prediction in MB
SizeFactor
Physical read factor for this cache size
This is the ratio of the number of estimated physical reads to the number of reads in the real cache.
CacheSize
Cache size for prediction in buffers
Phys.R. F.
Physical read factor.
This is the ratio of the number of estimated physical reads to the number of reads in the real cache.
PhysReads
Estimated number of physical reads for this cache size
Size for estimation
This tab page displays the same information as the table above for all size factors.
Shared pool advice
This tab page displays information to predict the number of physical reads for the cache size corresponding to each row.
The Oracle view GV$SHARED_POOL_ADVICE supplies the information displayed.
Full
This tab page groups the information by component and shows totals for all instances. It only shows size factor one.
Column
Description
InstID...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Size (MB)
Shared pool size for estimate
Sizefactor
Size factor with respect to the current shared pool size
lib. cache
Estimated memory in use by the library cache
Mem. Obj.
Number of library cache memory objects
Parse time
Estimated elapsed parse time saved (in seconds) because library cache memory objects are found in a shared pool of the specified size
ParseFact
Estimated parse time saved factor with respect to the current shared pool size
CacheHits
Estimated number of times a library cache memory object was found in a shared pool of the specified size
Size for estimation
This tab page displays the same information as the table above for all size factors.
Buffer pool statistic
The tab page displays information about all buffer pools available for the instance. The “sets” are the LRU latch sets.
The Oracle view GV$BUFFER_POOL_STATISTICS supplies the information displayed.
Column
Description
Inst ...
RAC only
Instance ID
Instance Name
RAC only
Instance name
Pool ID
Buffer pool identifier
Name
Buffer pool name
Block Size
Block size in bytes
Set MSi...
Buffer Pool Maximum Set Size
Repl.Lst
Number of buffers on replacement list
WriteList
Number of buffers on write list
B.In Set
Number of buffers in set
Got By Set
Number of buffers gotten by the set
Written
Number of buffers written by the set
Scanned
Number of buffers scanned in the set
Free wait
Free buffer wait statistic
WriteCompl
Write complete wait statistic
BusyWait
Buffer busy wait statistic
FreeInsp.
Free buffer inspected statistic
DirtyBuff.
Dirty buffers inspected statistic
BlkChange
Database blocks changed statistic
BlkGets
Database blocks gotten statistic
Cons.Gets
Consistent gets statistic
PhysReads
Physical reads statistic
PhysWrites
Physical writes statistic