Writer instructions | |
---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines |
SGA reports
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
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
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.