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
Item | Default Value | Changeable |
---|---|---|
Collection Interval | 3600 | Y |
Collection Offset | 1510 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Supported Version | Data Source |
---|---|---|---|---|---|---|
I/O Ops/sec (IO_RATE) | Number of I/O operations per second | AVG | double | No | All | (SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval |
Physical Reads (PHYSICAL_READS) | Number of physical read operations that were completed | AVG | double | Yes | All |
|
Physical Writes (PHYSICAL_WRITES) | Number of physical write operations that were completed | AVG | double | Yes | All |
|
Reads/sec (READ_RATE) | Number of read operations per second | 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 | COPY | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PMTS)#1 | COPY | string(4) | No | All | Remote Monitor Collector |
Rollback Segments (ROLLBACK_SEGMENTS) | Number of rollback segments. Performance data about a locally managed tablespace is not collected.#2 | AVG | ulong | No | All | COUNT(DBA_ROLLBACK_SEGS) |
Sort Segments (SORT_SEGMENTS) | Number of sort segments. Performance data about a locally managed permanent tablespace is not collected.#2 | AVG | ulong | No | All | COUNT(V$SORT_SEGMENT) |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | COPY | time_t | No | All | Remote Monitor Collector |
Tablespace Name (TABLESPACE_NAME) | Tablespace name | COPY | string(30) | No | All | DBA_TABLESPACES.TABLESPACE_NAME |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Writes/sec (WRITES_RATE) | Number of write operations per second | AVG | double | No | All |
|