List of records for PFM - RM for Oracle
This section lists the records that can be collected by PFM - RM for Oracle.
Table 5-10 lists the records that can be collected by PFM - RM for Oracle and the information that is stored in each record, in the order of record names and record IDs.
Note that if the monitoring target is Oracle Database 12c Release 2 or later in a CDB configuration, some records or fields collect the following performance data:
-
Performance data for the PDBs and root container (CDB$ROOT) that are being monitored
-
Performance data for all PDBs and common performance data for database instances
When monitoring a CDB configuration, the collection range of performance data might be different depending on the containers to be monitored and the fields to be acquired.
The following figures show differences in collection scope of performance data.
Also, depending on containers and fields to be monitored, there are fields with precautions and fields that cannot collect effective performance data.
For details, see Table 5-9 or the descriptions of each record field.
Record name |
Record ID |
Information stored in record |
Supported for monitoring |
||
---|---|---|---|---|---|
Non-CDB configuration #1 |
CDB configuration #2 |
||||
PDB |
Root container |
||||
Performance data indicating the operating status (at a specific point in time) of the Oracle system |
Y |
Y#3 |
N |
||
Performance data indicating the status (at a specific point in time) of the ASM disk managed by the ASM instance through which Oracle communicates |
Y |
Y#4 |
Y#4 |
||
Performance data, taken at specific intervals, about the ASM disk group managed by the ASM instance through which Oracle communicates |
Y |
Y#4 |
Y#4 |
||
Performance data indicating the status (at a specific point in time) of an instance and the fast recovery area. |
Y |
Y#4 |
Y#4 |
||
Performance data indicating the status (at a specific point in time) of tablespaces in a database |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of data files |
Y |
Y#5 |
N |
||
Performance data, taken at specific intervals, about data files |
Y |
Y#5 |
N |
||
Performance data, taken at a specific point in time, indicating the following:
|
Y |
Y#3 |
N |
||
Performance data, taken at specific intervals, about a database. |
Y |
Y#3 |
N |
||
Performance data indicating the status (at a specific point in time) of an instance |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of instance availability. |
Y |
Y#5 |
Y#6 |
||
Performance data indicating the status (at a specific point in time) of all sessions waiting for lock and all sessions holding lock |
Y |
Y#5 |
N |
||
Performance data, taken at specific intervals, about a database |
Y |
N |
N |
||
Performance data, taken at specific intervals, about data files |
Y |
N |
N |
||
Performance data, taken at specific intervals, about tablespaces in a database |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of cursors |
Y |
Y#5 |
N |
||
Performance data indicating the status (at a specific point in time) of current parameter values |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of sessions |
Y |
Y#3 |
N |
||
Performance data, taken at specific intervals, about input/output of all active sessions |
Y |
Y#3 |
N |
||
Performance data indicating the status (at a specific point in time) of each session and performance indicator of an instance |
Y |
Y#3 |
N |
||
Performance data indicating the status (at a specific point in time) of the system global area (SGA) |
Y |
Y#3 |
Y#7 |
||
Performance data indicating the status (at a specific point in time) of the SQL text for a cursor in the shared cursor cache |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of key performance indicators after the start of an instance |
Y |
Y#3 |
Y#4 |
||
Performance data, taken at specific intervals since the start of an instance, about key performance indicators |
Y |
Y#3 |
Y#4 |
||
Performance data indicating the status (at a specific point in time) of tablespaces in a database |
Y |
Y#5 |
Y#6 |
||
Performance data indicating the status (at a specific point in time) of fragmentation of tablespaces in a database |
Y |
Y#5 |
N |
||
Performance data, taken at specific intervals, about tablespaces in a database |
Y |
Y#5 |
N |
||
Performance data indicating the status (at a specific point in time) of transactions |
Y |
Y#5 |
N |
||
Performance data indicating the status (at a specific point in time) of transaction locks |
Y |
Y#5 |
N |
||
Database Link |
PD_PDDL |
This record is reserved and unavailable. |
N |
N |
N |
Ping Activity Interval |
PI_PIPP |
N |
N |
N |
|
SQL*Net Handler |
PD_PDNH |
N |
N |
N |
- #1
-
Applicable to Oracle Database 12c Release 1 or earlier, or Oracle Database 12c Release 2 in a non-CDB configuration.
- #2
-
The Oracle CDB configuration is supported as of Oracle Database 12c Release 2 or later. It is not supported for Oracle Database 12c Release 1.
- #3
-
Performance data for the PDBs that are being monitored and common performance data for database instances are collected.
- #4
-
Performance data for all PDBs and the root container (CDB$ROOT), and common performance data for database instances are collected.
- #5
-
Performance data for the PDBs that are being monitored is collected.
- #6
-
Performance data for the root container (CDB$ROOT) that is being monitored is collected.
- #7
-
The root container (CDB$ROOT) that is being monitored is collected following performance data:
-
Use administrative accounts (sys or system)
Performance data for all PDBs and the root container (CDB$ROOT), and common performance data for database instances are collected.
-
Use common user
Performance data for the root container (CDB$ROOT), and common performance data for database instances are collected.
This is difference of setting for collecting PDB's performance data. For details, see your Oracle documentation.
-