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
|