5. Records

This chapter describes the records for PFM - RM for Oracle. For details about collecting performance data for each type of record, see the chapter on Performance Management functionality in the Job Management Partner 1/Performance Management Planning and Configuration Guide or the chapter on management of operation monitoring data in the Job Management Partner 1/Performance Managementt User's Guide.

Organization of this chapter

Data model

Format of record explanations

List of ODBC key fields

Summary rules

List of data types

Field values

Fields added only when data is stored in the Store database

Fields output when data stored in the Store database is exported

Notes on records

List of records for PFM - RM for Oracle

Activity Summary (PD_PDAS)

Collection Instance 2 (PD_PCI)

Collection Tablespace 2(PD_PCTS)

Data File(PD_PDDF)

Data File Interval (PI_PIDF)

Database (PD_PDDB)

Database Interval (PI_PIDB)

Instance (PD_PDI)

Instance Availability (PD_PDIA)

Lock Waiters (PD_PDLW)

Minimum Database Interval 2 (PI_PMDB)

Minimum Data File Interval 2 (PI_PMDF)

Minimum Tablespace Interval 2 (PI_PMTS)

Open Cursor (PD_PDOC)

Parameter Values (PD_PDP)

Session Detail (PD_PDS)

Session I/O Interval (PI_PIIO)

Session Statistics Summary (PD_PDS2)

SGA Components (PD_PDSG)

SQL Text (PD_PDSQ)

System Stat Summary (PD)

System Stat Summary Interval (PI)

Tablespace (PD_PDTS)

Tablespace Fragmentation (PD_PDTF)

Tablespace Interval (PI_PITS)

Transaction (PD_PDTR)

Transaction Lock (PD_PDTL)