Snapshot Information Level Table Application |
API Structure(s) sqlm_table sqlm_appl sqlm_stmt sqlm_subsection |
Monitor Group Table Basic Basic Basic |
Resettable |
Yes |
|
Event Information Level Connection Table Statement Transaction |
API Structure(s) sqlm_conn_event sqlm_table_event sqlm_stmt_event sqlm_xaction_event |
|
API Element Name Element Type |
rows_written counter |
Description: This is the number of rows changed (inserted, deleted or updated).
Usage: A high value for table-level information indicates there is heavy usage of the table and you may want to use the Run Statistics (RUNSTATS) utility to maintain efficiency of the packages used for this table.
For application-connections and statements, this element includes the number of rows inserted, updated, and deleted in temporary tables.
At the application, transaction, and statement levels, this element can be useful for analyzing the relative activity levels, and for identifying candidates for tuning.
[ Top of Page | Table of Contents | Glossary | Index ]