Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
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 |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.