Collection Tablespace 2(PD_PCTS)

Function

The Collection Tablespace 2 (PD_PCTS) 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 transaction. This is a multi-instance record.

Default and changeable values

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

ODBC Key Fields

PD_PCTS_TABLESPACE_NAME

Lifetime

From the creation to the deletion of a tablespace

Record Size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported VersionData Source
Free Mbytes
(FREE_BYTES)
Remaining 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 tablespace 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 tablespace 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)
Mbytes
(BYTES)
Size of tablespace in megabytes--doubleNoAll
  • For dictionary managed permanent tablespaces, locally managed tablespaces, or dicationary managed temporary tablespaces:
    SUM(DBA_DATA_FILES.BYTES) / (1024 * 1024)
  • For locally managed temporary tablespaces:
    SUM(DBA_TEMP_FILES.BYTES) / (1024 * 1024)
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 PCTS)--string(4)NoAllRemote Monitor Collector
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Tablespace Name
(TABLESPACE_NAME)
Tablespace name--string(30)NoAllDBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent--string(256)NoAllRemote Monitor Collector