The Data File (PD_PDDF) record stores performance data indicating the status (at a specific point in time) of data files. PFM - RM for Oracle creates one record for each data file in the database. This is a multi-instance record.

Item	Default value	Changeable
Collection Interval	300	Y
Collection Offset	10	Y
Log	No	Y
LOGIF	(Blank)	Y

• PD_PDDF_FILE_NUM
• PD_PDDF_NAME

From the creation to the deletion of a data file

• Fixed part: 935 bytes
• Variable part: 672 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Blocks (BLOCKS)	Oracle block size	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: DBA_DATA_FILES.BLOCKS For locally managed temporary tablespaces: DBA_TEMP_FILES.BLOCKS
Checkpoint Change # (CHECKPOINT_CHANGE_NUM)	System change number (SCN) at the last checkpoint	--	double	No	All	V$DATAFILE.CHECKPOINT_CHANGE#
Enabled (ENABLED)	This field contains one of the following values as the method for accessing a file using SQL: DISABLED READ ONLY READ WRITE UNKNOWN	--	string(10)	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$DATAFILE.ENABLED For locally managed temporary tablespaces: V$TEMPFILE.ENABLED
File # (FILE_NUM)	File identification number	--	ulong	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	--	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
Free % (PERCENT_FREE)	Percentage ratio of free space	--	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, dictionary managed temporary tablespaces, or the UNDO tablespaces when the value of undospace_option is N: (SUM(DBA_FREE_SPACE.BYTES) / V$DATAFILE.BYTES) * 100 For locally managed temporary tablespaces when the value of localtemp_option is Y: ((V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / V$TEMPFILE.BYTES) * 100 For locally managed temporary tablespaces when the value of localtemp_option is N: (V$TEMP_SPACE_HEADER / V$TEMPFILE.BYTES) * 100 For the UNDO tablespaces when the value of undospace_option is Y: ((SUM(DBA_FREE_SPACE.BYTES) + SUM(DBA_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / V$DATAFILE.BYTES) * 100
Free Mbytes (FREE)	Size of free space in megabytes	--	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, dictionary managed temporary tablespaces, or the UNDO tablespaces when the value of undospace_option is N: SUM(DBA_FREE_SPACE.BYTES) / (1024 * 1024) For locally managed temporary tablespaces when the value of localtemp_option is Y: (V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (1024 * 1024) For locally managed temporary tablespaces when the value of localtemp_option is N: (V$TEMP_SPACE_HEADER.BYTES_FREE) / (1024 * 1024) For the UNDO tablespaces when the value of undospace_option is Y: (SUM(DBA_FREE_SPACE.BYTES) + SUM(DBA_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / (1024 x 1024)
MBytes (BYTES)	Disk space in megabytes required on the file system	--	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 Blocks Read (PHYSICAL_BLOCKS_READ)	Number of physical block read operations	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$FILESTAT.PHYBLKRD For locally managed temporary tablespaces: V$TEMPSTAT.PHYBLKRD
Physical Blocks Written (PHYSICAL_BLOCKS_WRITTEN)	Number of physical block write operations	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$FILESTAT.PHYBLKWRT For locally managed temporary tablespaces: V$TEMPSTAT.PHYBLKWRT
Physical Reads (PHYSICAL_READS)	Number of physical read operations that were completed	--	double	No	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 write operations that were completed	--	double	No	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
Read Time (READ_TIME)	Read operation time	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$FILESTAT.READTIM For locally managed temporary tablespaces: V$TEMPSTAT.READTIM
Record Time (RECORD_TIME)	Collection termination time for the performance data stored in the record	--	time_t	No	All	Remote Monitor Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always PDDF)	--	string(4)	No	All	Remote Monitor Collector
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	time_t	No	All	Remote Monitor Collector
Status (STATUS)	File type (system file or user file) and file status (OFFLINE, SYSOFF, ONLINE, SYSTEM, or RECOVER)	--	string(7)	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$DATAFILE.STATUS For locally managed temporary tablespaces: V$TEMPFILE.STATUS
Tablespace Name (TABLESPACE_NAME)	Tablespace name associated with the file	--	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
Used Mbytes (USED)	Size of used area in megabytes	--	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, dictionary managed temporary tablespaces, or the UNDO tablespaces when the value of undospace_option is N: (V$DATAFILE.BYTES - SUM(DBA_FREE_SPACE.BYTES)) / (1024 * 1024) For locally managed temporary tablespaces when the value of localtemp_option is Y: (V$TEMPFILE.BYTES - (V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED)) / (1024 * 1024) For locally managed temporary tablespaces when the value of localtemp_option is N: (V$TEMPFILE.BYTES - V$TEMP_SPACE_HEADER.BYTES_FREE) / (1024 * 1024) For the UNDO tablespaces when the value of undospace_option is Y: (V$DATAFILE.BYTES - SUM(DBA_FREE_SPACE.BYTES) - SUM(DBA_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / (1024 * 1024)
VA DeviceID (VADEVICEID)	Device ID of virtual agent	--	string(256)	No	All	Remote Monitor Collector
Write % (WRITE_PERCENTAGE)	Percentage ratio of write operations	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: (V$FILESTAT.PHYWRTS / (V$FILESTAT.PHYRDS + V$FILESTAT.PHYWRTS)) * 100 For locally managed temporary tablespaces: ((V$TEMPSTAT.PHYWRTS / (V$TEMPSTAT.PHYRDS + V$TEMPSTAT.PHYWRTS)) * 100
Write Time (WRITE_TIME)	Write operation time	--	double	No	All	For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces: V$FILESTAT.WRITETIM For locally managed temporary tablespaces: V$TEMPSTAT.WRITETIM