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.

Figure 6‒1: 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.

Table 6‒9: List of records for PFM - Agent for Oracle (record names)
Record name	Record ID	Information stored in record	Supported for monitoring
			Non-CDB configuration ^#1	CDB configuration ^#2
			Non-CDB configuration ^#1	PDB	Root container
Activity Summary	PD_PDAS	Performance data indicating the operating status (at a specific point in time) of the Oracle system.	Y	Y^#3	N
ASM Disk	PD_PDDK	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
ASM Disk Group Interval	PI_PIDG	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
Backup Async IO	PD_PDBA	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
Backup Sync IO	PD_PDBS	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
Block Contention Interval	PI_PIBC	Performance data, taken at specific intervals, about each wait class.	Y	N	N
Block Contention Statistics	PD_PDBC	Performance data indicating the status of each wait class at a specific point in time.w	Y	N	N
Buffer Pool	PD_PDBP	Performance data indicating the status of the buffer pool available to instances at a specific point in time.	Y	N	N
Cache Summary	PD_PDCS	Performance data indicating the status of each cache in the system global area (SGA) at a specific point in time.	Y	Y^#3	N
Cache Summary Interval	PI_PICS	Performance data, taken at specific intervals, about each cache in the system global area (SGA).	Y	Y^#3	N
CDB Status	PD_CDCS	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
CDB Tablespace	PD_CDTS	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
Circuit	PD_PDCI	Performance data indicating the status of circuits at a specific point in time.	Y	N	N
Collection Instance 2	PD_PCI	Performance data indicating the status (at a specific point in time) of an instance and the fast recovery area.	Y	Y^#4	Y^#4
Collection Tablespace 2	PD_PCTS	Performance data indicating the status (at a specific point in time) of tablespaces in a database.	Y	N	N
Control File	PD_PDCF	Performance data indicating the status of a control file at a specific point in time.	Y	N	N
Current Sessions Stat Summary	PD_PDS3	Performance data indicating the status of all active sessions for an instance at a specific point in time.	Y	Y^#3	N
Data Dictionary Cache	PD_PDDD	Performance data indicating the usage of the data dictionary cache at a specific point in time.	Y	N	N
Data Dictionary Cache Interval	PI_PIDD	Performance data, taken at specific intervals, about the usage of the data dictionary cache.	Y	N	N
Data File	PD_PDDF	Performance data indicating the status (at a specific point in time) of data files.	Y	Y^#5	N
Data File Interval	PI_PIDF	Performance data, taken at specific intervals, about data files.	Y	Y^#5	N
Database	PD_PDDB	Performance data, taken at a specific point in time, indicating the following: General information about a database Statistical information on tablespaces Statistical information on data files	Y	Y^#3	N
Database Interval	PI_PIDB	Performance data, taken at specific intervals, about a database.	Y	Y^#3	N
Database Object Cache	PD_PDDO	Performance data indicating the status of database objects in the library cache at a specific point in time.	Y	N	N
Dispatcher	PD_PDDS	Performance data indicating the status of dispatcher processes at a specific point in time.	Y	N	N
Dispatcher Interval	PI_PIDS	Performance data, taken at specific intervals, about dispatcher processes.	Y	N	N
Errorlog Detail	PD_PDEL	Performance data indicating the status of error messages in the database alert file at a specific point in time.	Y	Y^#5	N
GCS Stat Summary	PD_PDGC	Performance data indicating the status of the Global. Cache Service (GCS) at a specific point in time.	Y	Y^#5	N
GCS Stat Summary Interval	PI_PIGC	Performance data, taken at specific intervals, about the Global Cache Service (GCS).	Y	Y^#5	N
Instance	PD_PDI	Performance data indicating the status (at a specific point in time) of an instance.	Y	N	N
Instance Availability	PD_PDIA	Performance data indicating the status (at a specific point in time) of instance availability.	Y	Y^#5	Y^#6
Latch	PD_PDLA	Performance data indicating the status of latches at a specific point in time.	Y	Y^#3	N
Latch Interval	PI_PILA	Performance data, taken at specific intervals, about latches.	Y	Y^#3	N
Library Cache	PD_PDLC	Performance data indicating the status of library cache management at a specific point in time.	Y	N	N
Library Cache Interval	PI_PILC	Performance data, taken at specific intervals, about library cache management.	Y	N	N
Lock	PD_PDLO	Performance data indicating the status of locks at a specific point in time.	Y	N	N
Lock Activity Interval	PI_PIPL	Performance data, taken at specific intervals, about PCM lock conversions that have occurred.	N	N	N
Lock Interval	PI_PILO	Performance data, taken at specific intervals, about locks.	Y	N	N
Lock Waiters	PD_PDLW	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
Minimum Database Interval 2	PI_PMDB	Performance data, taken at specific intervals, about a database.	Y	N	N
Minimum Data File Interval 2	PI_PMDF	Performance data, taken at specific intervals, about data files.	Y	N	N
Minimum Tablespace Interval 2	PI_PMTS	Performance data, taken at specific intervals, about tablespaces in a database.	Y	N	N
Multi - Threaded Server	PD_PDMT	Performance data indicating the status of the multithread server (MTS) options at a specific point in time.	Y	N	N
Multi - Threaded Server Interval	PI_PIMT	Performance data, taken at specific intervals, about the multi-thread server (MTS) options.	Y	N	N
Open Cursor	PD_PDOC	Performance data indicating the status (at a specific point in time) of cursors.	Y	Y^#5	N
Options Installed	PD_PDO	Performance data indicating the status of the software options installed on the Oracle Server at a specific point in time.	Y	N	N
Parallel Query Server	PD_PDPQ	Performance data indicating the status of parallel query servers at a specific point in time.	Y	N	N
Parallel Query Server Interval	PI_PIPQ	Performance data, taken at specific intervals, about parallel query servers.	Y	N	N
Parallel Query Statistics	PD_PDPS	Performance data indicating the status of parallel query options at a specific point in time.	Y	N	N
Parameter Values	PD_PDP	Performance data indicating the status (at a specific point in time) of current parameter values.	Y	N	N
Process Detail	PD_PDOP	Performance data indicating the status of processes at a specific point in time.	Y	N	N
Queue Statistics	PD_PDQU	Performance data indicating the status of queues at a specific point in time.	Y	N	N
Resource Limit	PD_PDRL	Performance data indicating the usage of global system resources at a specific point in time.	Y	N	N
Rollback Segment	PD_PDRS	Performance data indicating the status of each rollback segment in a database at a specific point in time.	Y	N	N
Rollback Segment Interval	PI_PIRS	Performance data, taken at specific intervals, about each rollback segment in a database.	Y	N	N
Segment Detail	PD_PDSM	Performance data indicating the status of database segments at a specific point in time.	Y	N	N
Server Status	PD_STAT	Performance data indicating the status of the Oracle server at a specific point in time.	Y	N	N
Session Detail	PD_PDS	Performance data indicating the status (at a specific point in time) of sessions.	Y	Y^#3	N
Session Event	PD_PDEV	Performance data indicating the status of session events at a specific point in time.	Y	N	N
Session Event Interval	PI_PIEV	Performance data, taken at specific intervals, about session events.	Y	N	N
Session I/O Interval	PI_PIIO	Performance data, taken at specific intervals, about input/output of all active sessions.	Y	Y^#3	N
Session Stat Summary Interval	PI_PIS2	Performance data, taken at specific intervals, about each session and performance indicator of an instance.	Y	Y^#3	N
Session Statistics	PD_PDSS	Performance data indicating the status of sessions at a specific point in time.	Y	N	N
Session Statistics Summary	PD_PDS2	Performance data indicating the status (at a specific point in time) of each session and performance indicator of an instance.	Y	Y^#3	N
Session Wait	PD_PDWA	Performance data indicating the status of the session waits at a specific point in time.	Y	N	N
SGA Components	PD_PDSG	Performance data indicating the status (at a specific point in time) of the system global area (SGA).	Y	Y^#3	Y^#7
Shared Cursor Cache	PD_PDC	Performance data indicating the status of the shared cursor cache at a specific point in time.	Y	N	N
Shared Server	PD_PDSH	Performance data indicating the status of the shared servers at a specific point in time.	Y	N	N
Shared Server Interval	PI_PISH	Performance data, taken at specific intervals, about the shared servers.	Y	N	N
Sort Segment	PD_PDSR	Performance data indicating the status of sort segments in a database at a specific point in time.	Y	N	N
Sort Segment Interval	PI_PISR	Performance data, taken at specific intervals, about sort segments in a database.	Y	N	N
SQL Text	PD_PDSQ	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
SQL Text - Performance Based	PD_PDES	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
SQL*Net Listener	PD_PDNL	Performance data indicating the status of the status and overview of an SQL*Net Listener at a specific point in time.	Y	N	N
SQL*Net Listeners	PD_PDLS	Performance data indicating the status and overview of each defined listener at a specific point in time.	Y	Y^#5	N
System Event	PD_PDSE	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
System Event Interval	PI_PISE	Performance data, taken at specific intervals, about each queued event in an instance at the system level.	Y	N	N
System Stat Interval	PI_PIST	Metric information about sessions.	Y	N	N
System Stat Summary	PD	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
System Stat Summary Interval	PI	Performance data, taken at specific intervals since the start of an instance, about key performance indicators.	Y	Y^#3	Y^#4
System Statistics	PD_PDST	Performance data indicating the status of all sessions in the system at a specific point in time.	Y	N	N
Table Access	PD_PDTA	Performance data indicating the status of a table accessed by sessions during data collection at a specific point in time.	Y	N	N
Tablespace	PD_PDTS	Performance data indicating the status (at a specific point in time) of tablespaces in a database.	Y	Y^#5	Y^#6
Tablespace Fragmentation	PD_PDTF	Performance data indicating the status (at a specific point in time) of fragmentation of tablespaces in a database.	Y	Y^#5	N
Tablespace Interval	PI_PITS	Performance data, taken at specific intervals, about tablespaces in a database.	Y	Y^#5	N
Transaction	PD_PDTR	Performance data indicating the status (at a specific point in time) of transactions.	Y	Y^#5	N
Transaction Interval	PI_PITR	Performance data, taken at specific intervals, about transactions.	Y	Y^#5	N
Transaction Lock	PD_PDTL	Performance data indicating the status (at a specific point in time) of transaction locks.	Y	Y^#5	N
Version	PD_PDV	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

Legend:

Y: Supported

N: Not supported

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

To Page Top