SGA Components (PD_PDSG)

Function

The SGA Components (PD_PDSG) record stores performance data indicating the status (at a specific point in time) of the system global area (SGA). PFM - RM for Oracle creates one record for each system global area (SGA). This is a multi-instance record.

Default and changeable values

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset115Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PD_PDSG_NAME

Lifetime

From the creation to the deletion of an Oracle instance

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Bytes
(BYTES)
Memory size in bytes--doubleNoAll
  • V$SGASTAT.BYTES
  • V$SGA_DYNAMIC_COMPONENTS.CURRENT_SIZE
Component Name
(NAME)
Name of the SGA component--string(26)NoAll
  • V$SGASTAT.NAME
  • V$SGA_DYNAMIC_COMPONENTS.COMPONENT
Pool
(POOL)
Pools in which there is component name memory. There are four pools:
  • shared pool
  • large pool
  • java pool
  • streams pool
This field is blank when there is no applicable pool.
--string(12)No10-00 or later
  • V$SGASTAT.POOL
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDSG)--string(4)NoAllRemote Monitor Collector
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Total Bytes
(TOTAL_BYTES)
Total size of memory in bytes used by each SGA component--doubleNoAllV$SGASTAT.BYTES
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector