Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference


SGA Status Summary(7.0)

Organization of this page

Overview

The SGA Status Summary(7.0) report displays an overview of components in SGA per day over the past month.

Storage location

Reports/RM Oracle/Monthly Trend/Advanced/

Record

SGA Components (PD_PDSG)

Fields

Field name

Description

Bytes

Memory size (unit: bytes)

Component Name

SGA component name

Container ID

The ID of the container to which SGA component belongs.

This field is valid if the monitoring target is Oracle Database 12c R2 or later in a CDB configuration.

Otherwise, the value is 0.

PDB Bytes

Retrieves total size of memory for each Container ID field. The value can be either of the following:

  • If the Container ID is not 0, total size of memory of all SGA components that are allocated to PDBs or the root container (CDB$ROOT)

  • If the Container ID is 0, total size of memory of common SGA components of database instances

This field is valid if the monitoring target is Oracle Database 12c R2 or later in a CDB configuration.

Otherwise, the value is 0.

Total Bytes

Total size of memory used by each SGA component (unit: bytes)