This monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_LOAD contains information about executed SQL statements and access methods.
Value |
Explanation |
---|---|
Seconds since last init |
Seconds since last initialization of the system table |
SQL commands |
Number of executed SQL statements |
PREPAREs |
Number of parsed SQL statements |
PREPAREs repeated |
Number of SQL statements that were parsed again after metadata was changed |
EXECUTEs |
Number of executions of previously parsed SQL statements |
COMMITs |
Number of executed COMMIT statements |
ROLLBACKs |
Number of executed ROLLBACK statements |
LOCKs and UNLOCKs |
Number of executed LOCK and UNLOCK statements |
SUBTRANS BEGINs |
Number of SQL statements for opening a subtransaction |
SUBTRANS ENDs |
Number of SQL statements for closing a subtransaction |
SUBTRANS ROLLBACKs |
Number of SQL statements for rolling back a subtransaction |
CREATEs |
Number of executed SQL statements for creating database objects |
ALTERs |
Number of executed SQL statements for altering database objects |
DROPs |
Number of executed SQL statements for dropping database objects |
SELECTs and FETCHes |
Number of executed SQL statements for accessing data |
SELECTs and FETCHes, rows read |
Number of rows that were read when accessing data |
SELECTs and FETCHes, rows qual |
Number of rows that were read when accessing data and that satisfied conditions |
INSERTs |
Number of executed SQL statements for inserting rows |
INSERTs, rows inserted |
Number of rows inserted |
UPDATEs |
Number of executed SQL statements for updating rows |
UPDATEs, rows read |
Number of rows read when updating data |
UPDATEs, rows updated |
Number of rows updated |
DELETEs |
Number of executed SQL statements for deleting rows |
DELETEs, rows read |
Number of rows read when deleting data |
DELETEs, rows deleted |
Number of rows deleted |
Internal DBPROC calls |
Number of database procedures executed |
External DBPROC calls |
Number of external database procedure calls |
Internal trigger calls |
Number of triggers executed |
External trigger calls |
Number of external trigger calls |
Primary key accesses |
Number of search operations with direct access via the key |
Primary key accesses (IN strategy) |
Number of search operations with direct access via the key and IN search conditions |
Primary key accesses (SUBQ strategy) |
Number of search operations with access via the key and subqueries |
Primary key accesses, rows read |
Number of rows that were read by direct access using the key and that satisfied conditions |
Primary key accesses, rows qual |
Number of rows that were read by direct access using the key and that satisfied conditions |
Primary key range accesses |
Number of search operations with accesses within a range of keys |
Primary key range accesses, rows read |
Number of rows read within a range of keys |
Primary key range accesses, rows qual |
Number of rows read within a range of keys that satisfied the condition |
Index accesses |
Number of search operations with accesses to an index |
Index accesses (IN strategy) |
Number of search operations with accesses to an index and IN search conditions |
Index accesses (SUBQ strategy) |
Number of search operations with accesses to an index and subqueries |
Index scan |
Number of index searches |
Index accesses, rows read |
Number of rows that were indirectly accessed via an index |
Index accesses, rows qual |
Number of rows that were indirectly accessed via an index and that satisfied the condition |
Index range accesses |
Number of search operations using an index range |
Index range accesses, rows read |
Number of rows that were indirectly accessed via an index using an index range |
Index range accesses, rows qual |
Number of rows that satisfied the condition that were indirectly accessed via an index using an index range |
Isolated index accesses |
Number of search operations completely or partially satisfied by an index without accessing the corresponding base table rows |
Isolated index accesses (IN strategy) |
Number of search operations with an IN strategy completely or partially satisfied by an index without accessing the corresponding base table rows |
Isolated index accesses (SUBQ strategy) |
Number of search operations with a subquery strategy completely or partially satisfied by an index without accessing the corresponding base table rows |
Isolated index accesses, rows read |
Number of keys accessed within the search operations denoted in ISOLATED INDEX ACCESSES |
Isolated index accesses, rows qual |
Number of keys that were accessed within the search operations denoted in ISOLATED INDEX ACCESSES and that satisfied the condition |
Isolated index range accesses |
Number of search operations using a part of an index with values within a range without accessing the rows of the base table |
Isolated index range accesses, rows read |
Number of primary/secondary keys accessed within the search operations denoted by ISOLATED INDEX RANGE ACCESSES |
Isolated index range accesses, rows qual |
Number of primary/secondary keys that were accessed within the search operations denoted by ISOLATED INDEX RANGE ACCESSES and that satisfied the condition |
Table scans |
Number of search operations through the whole base table |
Table scans, rows read |
Number of rows that were accessed within search operations through the whole base table |
Table scans, rows qual |
Number of rows that were accessed within search operations through the whole base table and that satisfied the condition |
Isolated index scans |
Number of search operations for which a complete index was accessed without accessing rows of the base table |
Isolated index scans, rows read |
Number of index rows accessed within the search operations described under ISOLATED INDEX SCANS |
Isolated index scans, rows qual |
Number of index rows that were accessed within the search operations described under ISOLATED INDEX SCANS that satisfied the condition |
Memory sorts / sort&merge |
Number of sorting operations in the main memory to build temporary indexes |
Memory sorts / sort&merge, rows read |
Number of rows read to build temporary indexes |
Sorts by insertion |
Number of sorting operations by inserts |
Sorts by insertion, rows inserted |
Number of rows inserted during the sorting operation |
Join via Hash |
Number of joins using the hash procedure (hash joins) |
Hash join failed because of memory |
Number of hash joins that failed due to memory problems |
Hash join failed because of small buffer |
Number of hash joins that failed due to buffer being too small |
Join via parallel index read |
Number of joins constructed using parallel index read procedure |
Join via standard algorithm |
Number of joins constructed using standard algorithms |
Join via operator algorithm |
Number of joins constructed using operator algorithms |
Concepts of the Database System, SQL Optimizer, Search Strategies for Key Column Search Conditions, Search Strategies for Indexed Column Search Conditions, SUBQ CONDITION FOR KEY, SUBQ CONDITION FOR INDEX