MONITOR_ROW
The monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_ROW
contains information about operations on the row level.
Value |
Explanation |
|---|---|
|
Number of rows inserted in permanent tables |
|
Number of rows inserted in temporary tables |
|
Number of rows updated in permanent tables |
|
Number of rows updated in permanent tables using optimized access |
|
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. |
|
Number of rows updated in temporary tables |
|
Number of rows deleted from permanent tables |
|
Number of rows deleted from permanent tables using optimized access |
|
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. |
|
Number of rows deleted from temporary tables |
|
Number of rows selected from permanent tables using the key |
|
Number of rows selected from temporary tables using the key |
|
Number of rows selected from permanent tables using the predecessor key |
|
Number of rows selected from temporary tables using the predecessor key |
|
Number of rows selected from permanent tables using the successor key |
|
Number of rows selected from temporary tables using the successor key |
|
Number of rows selected using the key |
|
Number of rows selected using the predecessor key |
|
Number of rows selected using the successor key |
|
Number of insert operations in permanent indexes |
|
Number of insert operations in temporary indexes |
|
Number of delete operations from permanent indexes |
|
Number of delete operations from temporary indexes |
|
Number of accesses to permanent indexes |
|
Number of parallel accesses to permanent indexes |
|
Number of accesses to temporary indexes |