Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

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

Item Default value Changeable
Collection Interval 600 Y
Collection Offset 115 Y
Log No Y
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)
Description Summary Format Delta Supported version Data source
Bytes
(BYTES)
Memory size in bytes -- double No All
  • V$SGASTAT.BYTES
  • V$SGA_DYNAMIC_COMPONENTS.CURRENT_SIZE
Component Name
(NAME)
Name of the SGA component -- string(26) No All
  • 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) No 10-00 or later
  • V$SGASTAT.POOL
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record -- time_t No All Remote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDSG) -- string(4) No All Remote Monitor Collector
Start Time
(START_TIME)
Collection start time for the performance data stored in the record -- time_t No All Remote Monitor Collector
Total Bytes
(TOTAL_BYTES)
Total size of memory in bytes used by each SGA component -- double No All V$SGASTAT.BYTES
VA DeviceID
(VADEVICEID)
Device ID of virtual agent. -- string(256) No All Remote Monitor Collector