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 nameRecord IDInformation stored in record
Activity SummaryPD_PDASPerformance data indicating the operating status (at a specific point in time) of the Oracle system
Collection Instance 2PD_PCIPerformance data indicating the status (at a specific point in time) of an instance
Collection Tablespace 2PD_PCTSPerformance data indicating the status (at a specific point in time) of tablespaces in a database
Data FilePD_PDDFPerformance data indicating the status (at a specific point in time) of data files
Data File IntervalPI_PIDFPerformance data, taken at specific intervals, about data files
DatabasePD_PDDBPerformance 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 IntervalPI_PIDBPerformance data, taken at specific intervals, about a database.
InstancePD_PDIPerformance data indicating the status (at a specific point in time) of an instance
Instance AvailabilityPD_PDIAPerformance data indicating the status (at a specific point in time) of instance availability.
Lock WaitersPD_PDLWPerformance data indicating the status (at a specific point in time) of all sessions waiting for lock and all sessions holding lock
Minimum Database Interval 2PI_PMDBPerformance data, taken at specific intervals, about a database
Minimum Data File Interval 2PI_PMDFPerformance data, taken at specific intervals, about data files
Minimum Tablespace Interval 2PI_PMTSPerformance data, taken at specific intervals, about tablespaces in a database
Open CursorPD_PDOCPerformance data indicating the status (at a specific point in time) of cursors
Parameter ValuesPD_PDPPerformance data indicating the status (at a specific point in time) of current parameter values
Session DetailPD_PDSPerformance data indicating the status (at a specific point in time) of sessions
Session I/O IntervalPI_PIIOPerformance data, taken at specific intervals, about input/output of all active sessions
Session Statistics SummaryPD_PDS2Performance data indicating the status (at a specific point in time) of each session and performance indicator of an instance
SGA ComponentsPD_PDSGPerformance data indicating the status (at a specific point in time) of the system global area (SGA)
SQL TextPD_PDSQPerformance data indicating the status (at a specific point in time) of the SQL text for a cursor in the shared cursor cache
System Stat SummaryPDPerformance data indicating the status (at a specific point in time) of key performance indicators after the start of an instance
System Stat Summary IntervalPIPerformance data, taken at specific intervals since the start of an instance, about key performance indicators
TablespacePD_PDTSPerformance data indicating the status (at a specific point in time) of tablespaces in a database
Tablespace FragmentationPD_PDTFPerformance data indicating the status (at a specific point in time) of fragmentation of tablespaces in a database
Tablespace IntervalPI_PITSPerformance data, taken at specific intervals, about tablespaces in a database
TransactionPD_PDTRPerformance data indicating the status (at a specific point in time) of transactions
Transaction LockPD_PDTLPerformance data indicating the status (at a specific point in time) of transaction locks
Database LinkPD_PDDLThis record is reserved and unavailable.
Ping Activity IntervalPI_PIPP
SQL*Net HandlerPD_PDNH