Instance Availability (PD_PDIA)
Function
An Instance Availability (PD_PDIA) record stores performance data indicating the availability of an instance at a specific point in time. This record is immediately disconnected when a connection to an Oracle Database is attempted and successful. As such, due to data collection for other records, if an Oracle Database is already connected, there may temporarily be two connections.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | 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 name) | Description | Summary | Format | Delta | Supported version | Data source |
---|---|---|---|---|---|---|
Availability (AVAILABILITY) | Availability status#3, #4 Valid values are 0 (stopped) or 1 (running). If connection to an Oracle Database is impossible, 0 (stopped). If connection to an Oracle Database is possible, 1 (running). | -- | short | No | All | Remote Monitor Collector |
Collect Time (COLLECT_TIME) | Time required for processing to connect to and disconnect from an Oracle Database (in milliseconds) | -- | long | No | All | Remote Monitor Collector |
Error # (ERROR_NUM) | Error code when a connection to an Oracle Database is attempted and results in an error#5 This is blank when the connection is successful. | -- | string(10) | No | All | Remote Monitor Collector |
Record Time (RECORD_TIME) | Collection end time of performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name. This is always PDIA. | -- | string(4) | No | All | Remote Monitor Collector |
Start Time (START_TIME) | Collection start time of 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 |
Table 5-11 Examples of Error # field output and corresponding message codes
Example of Error # field output (Oracle error code) | Corresponding Oracle message code |
---|---|
28 | ORA-00028 |
1012 | ORA-01012 |
3113 | ORA-03113 |
3114 | ORA-03114 |
12571 | ORA-12571 |