Minimum Tablespace Interval 2 (PI_PMTS)

Function

The Minimum Tablespace Interval 2 (PI_PMTS) record stores performance data, taken at specific intervals, about 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 Offset1510Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PI_PMTS_TABLESPACE_NAME

Lifetime

From the creation to the deletion of a tablespace

Record Size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported VersionData Source
I/O Ops/sec
(IO_RATE)
Number of I/O operations per secondAVGdoubleNoAll(SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval
Physical Reads
(PHYSICAL_READS)
Number of physical read operations that were completedAVGdoubleYesAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    SUM(V$FILESTAT.PHYRDS)
  • For locally managed temporary tablespaces:
    SUM(V$TEMPSTAT.PHYRDS)
Physical Writes
(PHYSICAL_WRITES)
Number of physical write operations that were completedAVGdoubleYesAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    SUM(V$FILESTAT.PHYWRTS)
  • For locally managed temporary tablespaces:
    SUM(V$TEMPSTAT.PHYWRTS)
Reads/sec
(READ_RATE)
Number of read operations per secondAVGdoubleNoAllSUM(V$FILESTAT.PHYRDS)/ seconds in interval
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the recordCOPYtime_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PMTS)#1COPYstring(4)NoAllRemote Monitor Collector
Rollback Segments
(ROLLBACK_SEGMENTS)
Number of rollback segments. Performance data about a locally managed tablespace is not collected.#2AVGulongNoAllCOUNT(DBA_ROLLBACK_SEGS)
Sort Segments
(SORT_SEGMENTS)
Number of sort segments. Performance data about a locally managed permanent tablespace is not collected.#2AVGulongNoAllCOUNT(V$SORT_SEGMENT)
Start Time
(START_TIME)
Collection start time for the performance data stored in the recordCOPYtime_tNoAllRemote Monitor Collector
Tablespace Name
(TABLESPACE_NAME)
Tablespace nameCOPYstring(30)NoAllDBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Writes/sec
(WRITES_RATE)
Number of write operations per secondAVGdoubleNoAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    SUM(V$FILESTAT.PHYWRTS) / seconds in interval
  • For locally managed temporary tablespaces:
    SUM(V$TEMPSTAT.PHYWRTS) / seconds in interval