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.

Table 5‒9: List of records for PFM - RM for Oracle (record names)
Record name	Record ID	Information stored in record
Activity Summary	PD_PDAS	Performance data indicating the operating status (at a specific point in time) of the Oracle system
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
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
Collection Instance 2	PD_PCI	Performance data indicating the status (at a specific point in time) of an instance
Collection Tablespace 2	PD_PCTS	Performance data indicating the status (at a specific point in time) of tablespaces in a database
Data File	PD_PDDF	Performance data indicating the status (at a specific point in time) of data files
Data File Interval	PI_PIDF	Performance data, taken at specific intervals, about data files
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
Database Interval	PI_PIDB	Performance data, taken at specific intervals, about a database.
Instance	PD_PDI	Performance data indicating the status (at a specific point in time) of an instance
Instance Availability	PD_PDIA	Performance data indicating the status (at a specific point in time) of instance availability.
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
Minimum Database Interval 2	PI_PMDB	Performance data, taken at specific intervals, about a database
Minimum Data File Interval 2	PI_PMDF	Performance data, taken at specific intervals, about data files
Minimum Tablespace Interval 2	PI_PMTS	Performance data, taken at specific intervals, about tablespaces in a database
Open Cursor	PD_PDOC	Performance data indicating the status (at a specific point in time) of cursors
Parameter Values	PD_PDP	Performance data indicating the status (at a specific point in time) of current parameter values
Session Detail	PD_PDS	Performance data indicating the status (at a specific point in time) of sessions
Session I/O Interval	PI_PIIO	Performance data, taken at specific intervals, about input/output of all active sessions
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
SGA Components	PD_PDSG	Performance data indicating the status (at a specific point in time) of the system global area (SGA)
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
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
System Stat Summary Interval	PI	Performance data, taken at specific intervals since the start of an instance, about key performance indicators
Tablespace	PD_PDTS	Performance data indicating the status (at a specific point in time) of tablespaces in a database
Tablespace Fragmentation	PD_PDTF	Performance data indicating the status (at a specific point in time) of fragmentation of tablespaces in a database
Tablespace Interval	PI_PITS	Performance data, taken at specific intervals, about tablespaces in a database
Transaction	PD_PDTR	Performance data indicating the status (at a specific point in time) of transactions
Transaction Lock	PD_PDTL	Performance data indicating the status (at a specific point in time) of transaction locks
Database Link	`PD_PDDL`	This record is reserved and unavailable.
Ping Activity Interval	`PI_PIPP`
SQL*Net Handler	`PD_PDNH`

To Page Top