Minimum Database Interval 2 (PI_PMDB)
Function
The Minimum Database Interval 2 (PI_PMDB) record stores performance data, taken at specific intervals, about a database.
Default and changeable values
Item | Default Value | Changeable |
---|---|---|
Collection Interval | 3600 | Y |
Collection Offset | 1810 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC Key Fields
None
Lifetime
From the creation to the deletion of a database
Record Size
Fields
PFM - View name (PFM - Manager name) | Description | Summary | Format | Delta | Supported Version | Data Source |
---|---|---|---|---|---|---|
DB Name (NAME) | Database name | COPY | string(9) | No | All | V$DATABASE.NAME |
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 PMDB) | COPY | string(4) | No | All | Remote Monitor Collector |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | COPY | time_t | No | All | Remote Monitor Collector |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |