MONITOR_ROW

Definition

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

Structure

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 temp

Number of rows updated in temporary tables

BD del record perm

Number of rows deleted from permanent tables

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

See also:

MONITOR