List of records for PFM - Agent for Oracle
This section lists the records that can be collected by PFM - Agent for Oracle.
Table 6-9 lists the records that can be collected by PFM - Agent 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 6-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 a file that was backed up or restored with asynchronous I/O operations and that is now being or has been executed by the Oracle recovery manager (RMAN). |
Y |
N |
N |
||
Performance data indicating the status, at a specific point in time, of a file that was backed up or restored with synchronous I/O operations and that is now being or has been executed by the Oracle recovery manager (RMAN). |
Y |
N |
N |
||
Performance data, taken at specific intervals, about each wait class. |
Y |
N |
N |
||
Performance data indicating the status of each wait class at a specific point in time.w |
Y |
N |
N |
||
Performance data indicating the status of the buffer pool available to instances at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of each cache in the system global area (SGA) at a specific point in time. |
Y |
Y#3 |
N |
||
Performance data, taken at specific intervals, about each cache in the system global area (SGA). |
Y |
Y#3 |
N |
||
Performance data related to a PDB built inside a CDB, including open mode information and the status concerning the amount of disk space used. |
N |
Y#5 |
Y#4 |
||
Performance data indicating the status of tablespaces present in both the root container and PDBs of a CDB at a certain point in time. |
Y |
Y#5 |
Y#4 |
||
Performance data indicating the status of circuits at a specific point in time. |
Y |
N |
N |
||
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 of a control file at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of all active sessions for an instance at a specific point in time. |
Y |
Y#3 |
N |
||
Performance data indicating the usage of the data dictionary cache at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about the usage of the data dictionary cache. |
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 of database objects in the library cache at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of dispatcher processes at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about dispatcher processes. |
Y |
N |
N |
||
Performance data indicating the status of error messages in the database alert file at a specific point in time. |
Y |
Y#5 |
N |
||
Performance data indicating the status of the Global. Cache Service (GCS) at a specific point in time. |
Y |
Y#5 |
N |
||
Performance data, taken at specific intervals, about the Global Cache Service (GCS). |
Y |
Y#5 |
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 of latches at a specific point in time. |
Y |
Y#3 |
N |
||
Performance data, taken at specific intervals, about latches. |
Y |
Y#3 |
N |
||
Performance data indicating the status of library cache management at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about library cache management. |
Y |
N |
N |
||
Performance data indicating the status of locks at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about PCM lock conversions that have occurred. |
N |
N |
N |
||
Performance data, taken at specific intervals, about locks. |
Y |
N |
N |
||
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 of the multithread server (MTS) options at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about the multi-thread server (MTS) options. |
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 of the software options installed on the Oracle Server at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of parallel query servers at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about parallel query servers. |
Y |
N |
N |
||
Performance data indicating the status of parallel query options at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of current parameter values. |
Y |
N |
N |
||
Performance data indicating the status of processes at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of queues at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the usage of global system resources at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of each rollback segment in a database at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about each rollback segment in a database. |
Y |
N |
N |
||
Performance data indicating the status of database segments at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of the Oracle server at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status (at a specific point in time) of sessions. |
Y |
Y#3 |
N |
||
Performance data indicating the status of session events at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about session events. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about input/output of all active sessions. |
Y |
Y#3 |
N |
||
Performance data, taken at specific intervals, about each session and performance indicator of an instance. |
Y |
Y#3 |
N |
||
Performance data indicating the status of sessions at a specific point in time. |
Y |
N |
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 of the session waits at a specific point in time. |
Y |
N |
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 of the shared cursor cache at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of the shared servers at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about the shared servers. |
Y |
N |
N |
||
Performance data indicating the status of sort segments in a database at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about sort segments in a database. |
Y |
N |
N |
||
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 of the SQL text for an SQL statement that has resource requirements that exceed the specified maximum value at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of the status and overview of an SQL*Net Listener at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status and overview of each defined listener at a specific point in time. |
Y |
Y#5 |
N |
||
Performance data indicating the status of each queued event in an instance at the system level at a specific point in time. |
Y |
N |
N |
||
Performance data, taken at specific intervals, about each queued event in an instance at the system level. |
Y |
N |
N |
||
Metric information about sessions. |
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 of all sessions in the system at a specific point in time. |
Y |
N |
N |
||
Performance data indicating the status of a table accessed by sessions during data collection at a specific point in time. |
Y |
N |
N |
||
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, taken at specific intervals, about transactions. |
Y |
Y#5 |
N |
||
Performance data indicating the status (at a specific point in time) of transaction locks. |
Y |
Y#5 |
N |
||
Performance data, taken at a specific point in time, indicating the version number of a core component on the Oracle server. |
Y |
N |
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.
-