Instance Availability (PD_PDIA)
- Organization of this page
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 |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
None
Lifetime
From the creation to the deletion of an Oracle instance
Record size
-
Fixed part: 695 bytes
-
Variable part: 0 bytes
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 |
Agent Collector |
Collect Time (COLLECT_TIME) |
Time required for processing to connect to and disconnect from an Oracle Database (in milliseconds) |
-- |
long |
No |
All |
Agent 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 |
Agent Collector |
Record Time (RECORD_TIME) |
Collection end time of performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name. This is always PDIA. |
-- |
string(4) |
No |
All |
Agent Collector |
Start Time (START_TIME) |
Collection start time of performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
- #3
-
The value in the Availability field differs depending on the sqlnet value, which is instance information specified when an PFM - Agent for Oracle instance environment is configured. Table 6-11 Relationship Between the sqlnet Value and the Value in the Availability Field.
Table 6‒10: Relationship Between the sqlnet Value and the Value in the Availability Field Sqlnet value
Connection to Oracle Database
Value in the Availability field
Y
The listener is used to connect to Oracle Database.
The status of the availability of the listener and Oracle Database
N
The listener is not used to connect to Oracle Database.
The status of the availability of Oracle Database only
For details about other settings and procedures, see 2.1.4(3) Set up an instance environment or 3.1.4(4) Set up an instance environment.
- #4
-
If the maximum number of concurrent user sessions that can be recognized by an Oracle instance has been reached before PD_PDIA record collection (due to failed attempts to connect to the Oracle Database), the Availability field of a PD_PDIA record may be displayed as 0 (stopped), but other records may be obtained normally.
Likewise, when an Oracle instance stops running during record collection, the Availability field of a PD_PDIA record may be displayed as 0 (stopped), but other records may be obtained normally.
Also, when an Oracle instance stopped during record collection starts again, the Availability field of a PD_PDIA record may be displayed as 1 (running), but other records may not be able to be obtained.
- #5
-
The following table lists example output for the Error # field and the corresponding message code. The error codes in this table are output when Oracle is physically disconnected. For details about the messages that correspond to the Oracle message codes, see the Oracle documentation.
Table 6‒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