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 |
|
Component Name (NAME) | Name of the SGA component | -- | string(26) | No | All |
|
Pool (POOL) | Pools in which there is component name memory. There are four pools:
| -- | string(12) | No | 10-00 or later |
|
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 |