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.

Was this page helpful? Yes No Submitting... Thank you

Comments