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.

Item	Default Value	Changeable
Collection Interval	300	Y
Collection Offset	50	Y
Log	No	Y
LOGIF	(Blank)	Y

PI_PMDF_FILE_NUM

PI_PMDF_NAME

From the creation to the deletion of a data file

• Fixed part: 935 bytes
• Variable part: 655 bytes

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