PFM - View name (PFM - Manager name) | Description | Summary | Format | Delta | Supported version | Data source |
---|
Blocks (BLOCKS) | Size of tablespace in Oracle blocks | -- | ulong | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
SUM(DBA_DATA_FILES.BLOCKS)
- For locally managed temporary tablespaces:
SUM(DBA_TEMP_FILES.BLOCKS)
|
Data Files (DATAFILES) | Number of data files in use by the tablespace | -- | ulong | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
COUNT(DBA_DATA_FILES)
- For locally managed temporary tablespaces:
COUNT(DBA_TEMP_FILES)
|
Extents (EXTENTS) | Number of extents | -- | ulong | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or directory managed temporary tablespaces:
SUM(DBA_SEGMENTS.EXTENTS)
- For locally managed temporary tablespaces when the value of localtemp_option is Y:
SUM(DBA_TEMP_FILES.BYTES / V$TEMP_EXTENT_MAP.BYTES)
- For locally managed temporary tablespaces when the value of localtemp_option is N:
SUM(V$SORT_SEGMENT.TOTAL_EXTENTS)
|
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) / DBA_DATA_FILES.BYTES) * 100
- For locally managed temporary tablespaces when the value of localtemp_option is Y:
(SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (DBA_TEMP_FILES.BYTES)) * 100
- For locally managed temporary tablespaces when the value of localtemp_option is N:
(SUM(V$TEMP_SPACE_HEADER.BYTES_FREE) / (DBA_TEMP_FILES.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') / DBA_DATA_FILES.BYTES) * 100
|
Free Extents (FREE_EXTENTS) | Number of free extents. | -- | ulong | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
COUNT(DBA_FREE_SPACE)
- For locally managed temporary tablespaces when the value of localtemp_option is Y:
SUM((DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / V$TEMP_EXTENT_MAP.BYTES)
- For locally managed temporary tablespaces when the value of localtemp_option is N:
COUNT(V$TEMP_SPACE_HEADER)
|
Free Mbytes (FREE_BYTES) | 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:
SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (1024 * 1024)
- For locally managed temporary tablespaces when the value of localtemp_option is N:
SUM(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)
|
Increase % (PCT_INCREASE) | Default rate of increase in the extent size | -- | short | No | All | DBA_TABLESPACES.PCT_INCREASE |
Initial Extent (INITIAL_EXTENT) | Default size of the initial extent | -- | double | No | All | DBA_TABLESPACES.INITIAL_EXTENT |
Max Extents (MAX_EXTENTS) | Default maximum number of extents | -- | ulong | No | All | DBA_TABLESPACES.MAX_EXTENTS |
Mbytes (BYTES) | Size of the tablespace in megabytes | -- | double | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
SUM(DBA_DATA_FILES.BYTES) / (1024 * 1024)
- For locally managed temporary tablespaces:
SUM(DBA_TEMP_FILES.BYTES) / (1024 * 1024)
|
Min Extents (MIN_EXTENTS) | Default minimum number of extents | -- | long | No | All | DBA_TABLESPACES.MIN EXTENTS |
Next Extent (NEXT_EXTENT) | Default size of the incremental extent | -- | double | No | All | DBA_TABLESPACES.NEXT_EXTENT |
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 PDTS) | -- | string(4) | No | All | Remote Monitor Collector |
Segments (SEGMENTS) | Number of segments. Always 1 for locally managed temporary tablespaces when the value of localtemp_option is Y. | -- | ulong | No | All | - For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
COUNT(DBA_SEGMENTS)
- For locally managed temporary tablespaces when the value of localtemp_option is Y:
Remote Monitor Collector
- For locally managed temporary tablespaces when the value of localtemp_option is N:
COUNT(V$SORT_SEGMENT)
|
Start Time (START_TIME) | Collection start time for the performance data stored in the record | -- | Time_t | No | All | Remote Monitor Collector |
Status (STATUS) | Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, and ONLINE. | -- | string(9) | No | All | DBA_TABLESPACES STATUS |
Tablespace Name (TABLESPACE_NAME) | Tablespace name | -- | string(30) | No | All | DBA_TABLESPACES.TABLESPACE_NAME |
Used Mbytes (USED_BYTES) | 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:
(SUM(DBA_DATA_FILES.BYTES) -SUM(DBA_FREE_SPACE.BYTES)) / (1024 *1024)
- For locally managed temporary tablespaces when the value of localtemp_option is Y:
(SUM(DBA_TEMP_FILES.BYTES) - SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED)) / (1024 *1024)
- For locally managed temporary tablespaces when the value of localtemp_option is N:
(SUM(DBA_TEMP_FILES.BYTES) - SUM(V$TEMP_SPACE_HEADER.BYTES_FREE)) / (1024 *1024)
- For the UNDO tablespaces when the value of undospace_option is Y:
(DBA_DATA_FILES.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 |