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-10 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 |
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:
|
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 |