Tablespace Interval (PI_PITS)

Function

The Tablespace Interval (PI_PITS) 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 Offset50Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PI_PITS_TABLESPACE_NAME

Lifetime

From the creation to the deletion of a tablespace

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Datafiles
(DATAFILES)
Number of data files in use by the tablespace#2AVGulongNoAll
  • 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)
I/O Ops/sec
(IO_RATE)
Number of I/O operations per second#2AVGdoubleNoAll(SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval
Physical Blocks Read
(PHYSICAL_BLOCKS_READ)
Number of physical blocks read#2AVGdoubleYesAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    SUM(V$FILESTAT.PHYBLKRD)
  • For locally managed temporary tablespaces:
    SUM(V$TEMPSTAT.PHYBLKRD)
Physical Blocks Written
(PHYSICAL_BLOCKS_WRITTEN)
Number of physical blocks written#2AVGdoubleYesAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    SUM(V$FILESTAT.PHYBLKWRT)
  • Locally managed temporary tablespaces:
    SUM(V$TEMPSTAT.PHYBLKWRT)
Physical Reads
(PHYSICAL_READS)
Number of physical read operations that were completed#2AVGdoubleYesAll
  • 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 completed #2AVGdoubleYesAll
  • 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 second#2AVGdoubleNoAllSUM(V$FILESTAT.PHYRDS) / seconds in interval
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record#1COPYtime_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PITS)#1COPYstring(4)NoAllRemote Monitor Collector
Rollback Segments
(ROLLBACK_SEGMENTS)
Number of rollback segments.
Performance data about the locally managed tablespaces is not collected.#2
AVGulongNoAllCOUNT(DBA_ROLLBACK_SEGS)
Rollback Segments Hit %
(ROLLBACK_SEGMENTS_HIT_PERCENTAGE)
Percentage ratio of the HIT value to the GET value.
Performance data about locally managed tablespaces is not collected.#2
AVGdoubleNoAll((SUM(V$ROLLSTAT.GETS) - SUM(V$ROLLSTAT.WAITS)) / SUM(V$ROLLSTAT.GETS)) * 100
Rollback Segments Trans
(ROLLBACK_SEGMENTS_TRANS)
Number of transactions that were active during data collection.
Performance data about locally managed temporary tablespace is not collected.#2
AVGlongNoAllSUM(V$ROLLSTAT.XACTS)
Sort Segments
(SORT_SEGMENTS)
Number of sort segments.
Performance data about locally managed permanent tablespaces is not collected.#2
AVGulongNoAllCOUNT(V$SORT_SEGMENT)
Sorting Users
(SORTING_USERS)
Number of users that were active in the sort segment during data collection.
Perforamance data about locally managed permanent tablespaces is not collected.#2
AVGlongNoAllSUM(V$SORT_SEGMENT.CURRENT_USERS)
Start Time
(START_TIME)
Collection start time for the performance data stored in the record#1COPYtime_tNoAllRemote Monitor Collector
Tablespace Name
(TABLESPACE_NAME)
Tablespace name#1COPYstring(30)NoAllDBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Write %
(WRITE_PERCENTAGE)
Percentage ratio of write operations to all physical I/O operations #2AVGdoubleNoAll
  • For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces:
    (SUM(V$FILESTAT.PHYWRTS) / (SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS))) * 100
  • For locally managed temporary tablespaces:
    (SUM(V$TEMPSTAT.PHYWRTS) / SUM(V$TEMPSTAT.PHYWRTS) + SUM(V$TEMPSTAT.PHYRDS)) * 100
Writes/sec
(WRITES_RATE)
Number of write operations per second#2AVGdoubleNoAll
  • 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