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

Announcement Support for this product will end on December 22, 2025. To monitor Oracle databases, we recommend that you use PATROL for Oracle Enterprise Database.

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


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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*