Open object activity
(DBID, OBJECTID, INDEXID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| DB_NAME | string(32) | |
| OWNER_NAME | string(32) | |
| OBJECT_NAME | string(256) | |
| OBJTYPE | string(4) | |
| OBJECTTYPE | string(24) | |
| DBID | long | Database ID |
| OBJECTID | long | |
| INDEXID | long | |
| LOGICALREADS | long | |
| PHYSICALREADS | long | |
| APFREADS | long | |
| PAGESREAD | long | |
| PHYSICALWRITES | long | |
| PAGESWRITTEN | long | |
| OPTSELECTCOUNT | long | |
| USEDCOUNT | long | |
| ROWSINSERTED | long | |
| ROWSDELETED | long | |
| ROWSUPDATED | long | |
| OPERATIONS | long | |
| LOCKREQUESTS | long | |
| LOCKWAITS | long | |
| LASTOPTSELECTDATE | time | |
| LASTUSEDDATE | time | |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| LOGICALREADS_DELTA | double | |
| LOGICALREADS_OVERALL | double | |
| LOGICALREADS_RATE | double | |
| LOGICALREADS_RATE_AVG | double | |
| PHYSICALREADS_DELTA | double | |
| PHYSICALREADS_OVERALL | double | |
| PHYSICALREADS_RATE | double | |
| PHYSICALREADS_RATE_AVG | double | |
| PHYSICALWRITES_DELTA | double | |
| PHYSICALWRITES_OVERALL | double | |
| PHYSICALWRITES_RATE | double | |
| PHYSICALWRITES_RATE_AVG | double | |
| LOGICALIO_DELTA | double | |
| LOGICALIO_OVERALL | double | |
| LOGICALIO_RATE | double | |
| LOGICALIO_RATE_AVG | double | |
| OPERATIONS_DELTA | double | |
| OPERATIONS_OVERALL | double | |
| IO_PER_OP_DELTA | double | |
| IO_PER_OP_OVERALL | double | |
| ROWSINSERTED_DELTA | double | |
| ROWSINSERTED_OVERALL | double | |
| ROWSDELETED_DELTA | double | |
| ROWSDELETED_OVERALL | double | |
| ROWSUPDATED_DELTA | double | |
| ROWSUPDATED_OVERALL | double | |
| LOCKREQUESTS_DELTA | double | |
| LOCKREQUESTS_OVERALL | double | |
| LOCKWAITS_DELTA | double | |
| LOCKWAITS_OVERALL | double | |
| LOCKWAITPCT | double | |
| LOCKWAITPCT_OVERALL | double | |
| APFREADS_DELTA | double | |
| APFREADS_OVERALL | double | |
| PHYSICALIO_DELTA | double | |
| PHYSICALIO_OVERALL | double | |
| PHYSICALIO_RATE | double | |
| PHYSICALIO_RATE_AVG | double |
| Attributes: | MDA (and no CE) |
|---|---|
| Minimum database version: | 12.5.0.3 |