Tablespace (PD_PDTS)

Function

The Tablespace (PD_PDTS) record stores performance data indicating the status (at a specific point in time) of tablespaces in a database. PFM - RM for Oracle creates one record for each tablespace in a database. This is a multi-instance record.

Default and changeable values

ItemDefault valueChangeable
Collection Interval3600Y
Collection Offset30Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PD_PDTS_TABLESPACE_NAME

Lifetime

From the creation to the deletion of a tablespace

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Blocks
(BLOCKS)
Size of tablespace in Oracle blocks--ulongNoAll
  • 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--ulongNoAll
  • 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--ulongNoAll
  • 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--doubleNoAll
  • 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.--ulongNoAll
  • 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.--doubleNoAll
  • 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--shortNoAllDBA_TABLESPACES.PCT_INCREASE
Initial Extent
(INITIAL_EXTENT)
Default size of the initial extent--doubleNoAllDBA_TABLESPACES.INITIAL_EXTENT
Max Extents
(MAX_EXTENTS)
Default maximum number of extents--ulongNoAllDBA_TABLESPACES.MAX_EXTENTS
Mbytes
(BYTES)
Size of the tablespace in megabytes--doubleNoAll
  • 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--longNoAllDBA_TABLESPACES.MIN EXTENTS
Next Extent
(NEXT_EXTENT)
Default size of the incremental extent--doubleNoAllDBA_TABLESPACES.NEXT_EXTENT
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDTS)--string(4)NoAllRemote Monitor Collector
Segments
(SEGMENTS)
Number of segments.
Always 1 for locally managed temporary tablespaces when the value of localtemp_option is Y.
--ulongNoAll
  • 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_tNoAllRemote Monitor Collector
Status
(STATUS)
Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, and ONLINE.--string(9)NoAllDBA_TABLESPACES STATUS
Tablespace Name
(TABLESPACE_NAME)
Tablespace name--string(30)NoAllDBA_TABLESPACES.TABLESPACE_NAME
Used Mbytes
(USED_BYTES)
Size of used area in megabytes.--doubleNoAll
  • 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)NoAllRemote Monitor Collector