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
Item | Default Value | Changeable |
---|---|---|
Collection Interval | 300 | Y |
Collection Offset | 50 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Supported Version | Data Source |
---|---|---|---|---|---|---|
File # (FILE_NUM) | File identification number | COPY | ushort | No | All | For 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 name | COPY | string(513) | No | All | For 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 second | AVG | double | No | All | For 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 megabytes | COPY | double | No | All | For 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 interval | AVG | double | Yes | All | For 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 interval | AVG | double | Yes | All | For 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 second | AVG | double | No | All | For 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 record | COPY | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PMDF) | COPY | string(4) | No | All | Remote Monitor Collector |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | COPY | time_t | No | All | Remote Monitor Collector |
Tablespace Name (TABLESPACE_NAME) | Tablespace name associated with the file | COPY | string(30) | No | All | For 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) | No | All | Remote Monitor Collector |
Writes/sec (WRITES_RATE) | Number of write operations per second | AVG | double | No | All | For 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 |