Minimum Data File Interval 2 (PI_PMDF)

Function

The Minimum Data File Interval 2 (PI_PMDF) record stores performance data, taken at specific intervals, about data files. PFM - RM for Oracle creates one record for each data file in a database. This is a multi-instance record.

Default and changeable values

ItemDefault ValueChangeable
Collection Interval300Y
Collection Offset50Y
LogNoY
LOGIF(Blank)Y

ODBC Key Fields

PI_PMDF_FILE_NUM

PI_PMDF_NAME

Lifetime

From the creation to the deletion of a data file

Record Size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported VersionData Source
File #
(FILE_NUM)
File identification numberCOPYushortNoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$DATAFILE.FILE#
For locally managed temporary tablespaces:
V$TEMPFILE.FILE#
File Name
(NAME)
File nameCOPYstring(513)NoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$DATAFILE.NAME
For locally managed temporary tablespaces:
V$TEMPFILE.NAME
I/O Ops/sec
(IO_RATE)
Number of I/O operations per secondAVGdoubleNoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
(V$FILESTAT.PHYRDS + V$FILESTAT.PHYWRTS) / seconds in interval
For locally managed temporary tablespaces:
(V$TEMPSTAT.PHYRDS + V$TEMPSTAT.PHYWRTS) / seconds in interval
Mbytes
(BYTES)
Percentage of disk space used by a file system, in megabytesCOPYdoubleNoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$DATAFILE.BYTES / (1024 * 1024)
For locally managed temporary tablespaces:
V$TEMPFILE.BYTES / (1024 * 1024)
Physical Reads
(PHYSICAL_READS)
Number of physical block read operations that were completed during the intervalAVGdoubleYesAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$FILESTAT.PHYRDS
For locally managed temporary tablespaces:
V$TEMPSTAT.PHYRDS
Physical Writes
(PHYSICAL_WRITES)
Number of physical block write operations that were completed during the intervalAVGdoubleYesAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$FILESTAT.PHYWRTS
For locally managed temporary tablespaces:
V$TEMPSTAT.PHYWRTS
Reads/sec
(READ_RATE)
Number of read operations per secondAVGdoubleNoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$FILESTAT.PHYRDS / seconds in interval
For locally managed temporary tablespaces:
V$TEMPSTAT.PHYRDS / seconds in interval
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the recordCOPYtime_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PMDF)COPYstring(4)NoAllRemote Monitor Collector
Start Time
(START_TIME)
Collection start time for the performance data stored in the recordCOPYtime_tNoAllRemote Monitor Collector
Tablespace Name
(TABLESPACE_NAME)
Tablespace name associated with the fileCOPYstring(30)NoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
DBA_DATA_FILES.TABLESPACE_NAME
For locally managed temporary tablespaces:
DBA_TEMP_FILES.TABLESPACE_NAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Writes/sec
(WRITES_RATE)
Number of write operations per secondAVGdoubleNoAllFor dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:
V$FILESTAT.PHYWRTS / seconds in interval
For locally managed temporary tablespaces:
V$TEMPSTAT.PHYWRTS / seconds in interval