SGA reports
Warning
This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.
Because tuning any part of the Oracle server or database involves the system global area ( SGA), you must tune the SGA as well. You can use the following reports to view the current memory usage in the SGA.
- SGA Information
- SGA Memory Analysis Report
- Shared Pool Report
- Buffer Pool Information
- Buffer/Lib/Dict Cache Info Report
- Buffer Cache Contents Report Redo Log Cache Report
Before you can manage the job queue, you must activate the SGA application by choosing KM Admin > Monitor Settings Modify from the INSTANCE menu and enabling the SGA category.
The CollSGA parameter starts collecting information about the next polling cycle, and then populates the consumer parameters. The SGA icon should appear within two polling cycles.
Getting SGA memory information
Use the following reports to get information about the components that are in the SGA and the activity in the shared pool in the SGA.
SGA memory information
The SGA Memory Analysis report shows how the SGA components are using memory.
Choose Reports > SGA > SGA Memory Analysis from the INSTANCE menu, or Reports > SGA Memory Analysis from the SGA menu.
The following table shows the information that the report provides.
SGA Memory Analysis report
Item | Description |
|---|---|
SGA Component Name | SGA component name |
Size (bytes) | Size of the SGA memory in bytes |
SGA shared pool information
The Shared Pool report shows how memory is being used in the SGA shared pool.
Choose Reports > SGA > Shared Pool from the INSTANCE menu, or Reports > Shared Pool from the SGA menu.
The following table shows the information that the report provides.
Shared Pool report
Item | Description |
|---|---|
Name Space | name of the library cache namespace |
Gets | number of times a lock was requested for this namespace |
Get Hits | number of times a lock was requested and granted for this namespace |
Get Hit Ratio | percentage of all attempts to lock library cache entries that were immediately successful |
Pins | number of times a library cache entry was executed in this namespace |
Pin Hits | number of times a library cache entry was successfully executed |
Pin Hit Ratio | percentage of all attempts to access a library cache entry that were immediately successful because the entry was present in its entirety |
Reloads | number of times a library cache entry was reloaded into the cache |
Invalidations | total number of times library cache entries were marked invalid because a dependent object was modified |
Getting buffer pool and buffer cache information
The following reports provide information about buffer pool use. All objects that are currently in the buffer cache except those owned by SYS are reported.
Viewing buffer cache information
Choose Reports > SGA > Buffer Cache from the INSTANCE menu, or Reports > Buffer Cache from the SGA menu.
The following table shows the information that the report provides.
Buffer Cache Contents report
| Item | Description |
| Object Name | name of the object currently in the buffer cache |
| Object Type | type of the object currently in the buffer cache |
| Header Blocks | number of headers in the buffer cache |
| Data Blocks | number of data blocks in the buffer cache |
| CR Blocks | number of consistent blocks in the buffer cache |
| Summary Section | |
| Data dictionary headers | number of headers from the data dictionary |
| Data dictionary data | number of data dictionary blocks in the buffer cache |
| Data dictionary consistent read | number of consistent reads in the data dictionary |
| Free buffers | number of free buffers |
| Rollback segment headers | number of rollback segment headers in the buffer cache |
| Rollback segment entries | number of rollback segment entries |
| Unknown segment general | number of unknown segments |
| Unknown segment consistent read | number of consistent reads for unknown segments |
| User objects headers | number of user object headers in the buffer cache |
| User Objects Data | number of user objects data in the buffer cache |
| User objects consistent read | number of consistent reads on user objects |
| Total | total number of objects, headers, and segments in the buffer cache |
Viewing buffer, dictionary, and library cache information
This report lists buffer, dictionary, and library cache information for the instance. The values for the following parameters are listed:
- BuffHitRatio
- BuffBusyRate
- DictHitRatio
- LibGetHitRatio
- LibGetPinRatio
Choose Reports > SGA > Buffer/Lib/Dict Cache Info from the INSTANCE menu, or Reports > Buffer/Lib/Dict Cache Info from the SGA menu.
Viewing redo log cache information
This report lists the ratio of gets to misses for the redo log buffer cache. Use this report to ensure there are no wait conditions in the redo log buffer cache.
Choose Reports > SGA > Redo Logs Buffer Cache from the INSTANCE menu, or Reports > Redo Log Buffer Cache from the SGA menu.
Comments