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.

Item	Default value	Changeable
Collection Interval	60	Y
Collection Offset	0	Y
Log	No	Y
LOGIF	(Blank)	Y

None

From the creation to the deletion of an Oracle instance

• Fixed part: 952 bytes
• Variable part: 0 bytes

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

#3

PFM - RM for Oracle connects to Oracle Database via listener. For this reason, availability field means the availability status of listener and Oracle Database.

#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 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