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
Item | Default Value | Changeable |
---|---|---|
Collection Interval | 3600 | Y |
Collection Offset | 30 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Supported Version | Data Source |
---|---|---|---|---|---|---|
Free Mbytes (FREE_BYTES) | Remaining free space in megabytes. | -- | double | No | All |
|
Mbytes (BYTES) | Size of tablespace in megabytes | -- | double | No | All |
|
Record Time (RECORD_TIME) | Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PCTS) | -- | string(4) | No | All | Remote Monitor Collector |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Tablespace Name (TABLESPACE_NAME) | Tablespace name | -- | string(30) | No | All | DBA_TABLESPACES.TABLESPACE_NAME |
VA DeviceID (VADEVICEID) | Device ID of virtual agent | -- | string(256) | No | All | Remote Monitor Collector |