Collection Instance 2 (PD_PCI)
Function
The Collection Instance 2 (PD_PCI) record stores performance data indicating the status (at a specific point in time) of an instance.
Default and changeable values
Item | Default Value | Changeable |
---|---|---|
Collection Interval | 600 | Y |
Collection Offset | 40 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC Key Fields
None
Lifetime
From the creation to the deletion of an Oracle instance
Record Size
Fields
PFM - View name (PFM - Manager ame) | Description | Summary | Format | Delta | Supported Version | Data Source |
---|---|---|---|---|---|---|
Host (HOST) | Instance's host machine name | -- | string(64) | No | All | V$INSTANCE.HOST_NAME |
ORACLE_HOME (ORACLE_HOME) | ORACLE_HOME environment variable | -- | string(255) | No | All | -- |
ORACLE_SID (ORACLE_SID) | ORACLE_SID environment variable | -- | string(30) | No | All | -- |
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 PCI) | -- | 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 |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Version (VERSION) | Version of Oracle database | -- | string(20) | No | All | PRODUCT_COMPONENT_VERSION |