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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 3600 | Y |
Collection Offset | 50 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Supported version | Data source |
---|---|---|---|---|---|---|
Datafiles (DATAFILES) | Number of data files in use by the tablespace#2 | AVG | ulong | No | All |
|
I/O Ops/sec (IO_RATE) | Number of I/O operations per second#2 | AVG | double | No | All | (SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval |
Physical Blocks Read (PHYSICAL_BLOCKS_READ) | Number of physical blocks read#2 | AVG | double | Yes | All |
|
Physical Blocks Written (PHYSICAL_BLOCKS_WRITTEN) | Number of physical blocks written#2 | AVG | double | Yes | All |
|
Physical Reads (PHYSICAL_READS) | Number of physical read operations that were completed#2 | AVG | double | Yes | All |
|
Physical Writes (PHYSICAL_WRITES) | Number of physical write operations that were completed #2 | AVG | double | Yes | All |
|
Reads/sec (READ_RATE) | Number of read operations per second#2 | AVG | double | No | All | SUM(V$FILESTAT.PHYRDS) / seconds in interval |
Record Time (RECORD_TIME) | Collection termination time for the performance data stored in the record#1 | COPY | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PITS)#1 | COPY | string(4) | No | All | Remote Monitor Collector |
Rollback Segments (ROLLBACK_SEGMENTS) | Number of rollback segments. Performance data about the locally managed tablespaces is not collected.#2 | AVG | ulong | No | All | COUNT(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 | AVG | double | No | All | ((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 | AVG | long | No | All | SUM(V$ROLLSTAT.XACTS) |
Sort Segments (SORT_SEGMENTS) | Number of sort segments. Performance data about locally managed permanent tablespaces is not collected.#2 | AVG | ulong | No | All | COUNT(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 | AVG | long | No | All | SUM(V$SORT_SEGMENT.CURRENT_USERS) |
Start Time (START_TIME) | Collection start time for the performance data stored in the record#1 | COPY | time_t | No | All | Remote Monitor Collector |
Tablespace Name (TABLESPACE_NAME) | Tablespace name#1 | COPY | string(30) | No | All | DBA_TABLESPACES.TABLESPACE_NAME |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Write % (WRITE_PERCENTAGE) | Percentage ratio of write operations to all physical I/O operations #2 | AVG | double | No | All |
|
Writes/sec (WRITES_RATE) | Number of write operations per second#2 | AVG | double | No | All |
|