Object documentationMONITOR_ROW Locate this document in the navigation structure

 

The monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_ROW contains information about operations on the row level.

Structure

MONITOR_ROW, DESCRIPTION Column

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

More Information

MONITOR