The monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_ROW contains information about operations on the row level.
Value |
Explanation |
---|---|
BD add record perm |
Number of rows inserted in permanent tables |
BD add record temp |
Number of rows inserted in temporary tables |
BD repl record perm |
Number of rows updated in permanent tables |
BD repl record perm optimized |
Number of rows updated in permanent tables using optimized access |
BD repl record perm optimization failed |
Number of rows updated in permanent tables, but the optimized access failed. The leaf page number hint from the qualification test could not be used to update the qualified record. |
BD repl record temp |
Number of rows updated in temporary tables |
BD del record perm |
Number of rows deleted from permanent tables |
BD del record perm optimized |
Number of rows deleted from permanent tables using optimized access |
BD del record perm optimization failed |
Number of rows deleted in permanent tables, but the optimized access failed. The leaf page number hint from the qualification test could not be used to delete the qualified record. |
BD del record temp |
Number of rows deleted from temporary tables |
BD get record perm |
Number of rows selected from permanent tables using the key |
BD get record temp |
Number of rows selected from temporary tables using the key |
BD next record perm |
Number of rows selected from permanent tables using the predecessor key |
BD next record temp |
Number of rows selected from temporary tables using the predecessor key |
BD prev record perm |
Number of rows selected from permanent tables using the successor key |
BD prev record temp |
Number of rows selected from temporary tables using the successor key |
BD select direct record |
Number of rows selected using the key |
BD select next record |
Number of rows selected using the predecessor key |
BD select prev record |
Number of rows selected using the successor key |
BD add to index list perm |
Number of insert operations in permanent indexes |
BD add to index list temp |
Number of insert operations in temporary indexes |
BD del from index list perm |
Number of delete operations from permanent indexes |
BD del from index list temp |
Number of delete operations from temporary indexes |
BD get index list perm |
Number of accesses to permanent indexes |
BD get index list perm parallel |
Number of parallel accesses to permanent indexes |
BD get index list temp |
Number of accesses to temporary indexes |