SGA Monitor 
This submonitor in the SAP/Oracle Database Monitor lets you monitor the System Global Area (SGA).
Use
You choose Detailed Analyses ® Resource Consumption ® SGA Monitor.
You can view history information in this monitor.
Structure
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 |
Inst ID… 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 |