6. Records

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 - Agent for Oracle

• Activity Summary (PD_PDAS)

• ASM Disk (PD_PDDK)

• ASM Disk Group Interval (PI_PIDG)

• Backup Async IO (PD_PDBA)

• Backup Sync IO (PD_PDBS)

• Block Contention Interval (PI_PIBC)

• Block Contention Statistics (PD_PDBC)

• Buffer Pool (PD_PDBP)

• Cache Summary (PD_PDCS)

• Cache Summary Interval (PI_PICS)

• CDB Status (PD_CDCS)

• CDB Tablespace(PD_CDTS)

• Circuit (PD_PDCI)

• Collection Instance 2 (PD_PCI)

• Collection Tablespace 2(PD_PCTS)

• Control File (PD_PDCF)

• Current Sessions Stat Summary (PD_PDS3)

• Data Dictionary Cache (PD_PDDD)

• Data Dictionary Cache Interval (PI_PIDD)

• Data File (PD_PDDF)

• Data File Interval (PI_PIDF)

• Database (PD_PDDB)

• Database Interval (PI_PIDB)

• Database Object Cache (PD_PDDO)

• Dispatcher (PD_PDDS)

• Dispatcher Interval (PI_PIDS)

• Errorlog Detail (PD_PDEL)

• GCS Stat Summary (PD_PDGC)

• GCS Stat Summary Interval (PI_PIGC)

• Instance (PD_PDI)

• Instance Availability (PD_PDIA)

• Latch (PD_PDLA)

• Latch Interval (PI_PILA)

• Library Cache (PD_PDLC)

• Library Cache Interval (PI_PILC)

• Lock (PD_PDLO)

• Lock Activity Interval (PI_PIPL)

• Lock Interval (PI_PILO)

• Lock Waiters (PD_PDLW)

• Minimum Database Interval 2 (PI_PMDB)

• Minimum Data File Interval 2 (PI_PMDF)

• Minimum Tablespace Interval 2 (PI_PMTS)

• Multi - Threaded Server (PD_PDMT)

• Multi - Threaded Server Interval (PI_PIMT)

• Open Cursor (PD_PDOC)

• Options Installed (PD_PDO)

• Parallel Query Server (PD_PDPQ)

• Parallel Query Server Interval (PI_PIPQ)

• Parallel Query Statistics (PD_PDPS)

• Parameter Values (PD_PDP)

• Process Detail (PD_PDOP)

• Queue Statistics (PD_PDQU)

• Resource Limit (PD_PDRL)

• Rollback Segment (PD_PDRS)

• Rollback Segment Interval (PI_PIRS)

• Segment Detail (PD_PDSM)

• Server Status (PD_STAT)

• Session Detail (PD_PDS)

• Session Event (PD_PDEV)

• Session Event Interval (PI_PIEV)

• Session I/O Interval (PI_PIIO)

• Session Stat Summary Interval (PI_PIS2)

• Session Statistics (PD_PDSS)

• Session Statistics Summary (PD_PDS2)

• Session Wait (PD_PDWA)

• SGA Components (PD_PDSG)

• Shared Cursor Cache (PD_PDC)

• Shared Server (PD_PDSH)

• Shared Server Interval (PI_PISH)

• Sort Segment (PD_PDSR)

• Sort Segment Interval (PI_PISR)

• SQL Text (PD_PDSQ)

• SQL Text - Performance Based (PD_PDES)

• SQL*Net Listener (PD_PDNL)

• SQL*Net Listeners (PD_PDLS)

• System Event (PD_PDSE)

• System Event Interval (PI_PISE)

• System Stat Interval (PI_PIST)

• System Stat Summary (PD)

• System Stat Summary Interval (PI)

• System Statistics (PD_PDST)

• Table Access (PD_PDTA)

• Tablespace (PD_PDTS)

• Tablespace Fragmentation (PD_PDTF)

• Tablespace Interval (PI_PITS)

• Transaction (PD_PDTR)

• Transaction Interval (PI_PITR)

• Transaction Lock (PD_PDTL)

• Version (PD_PDV)

To Page Top