|
Snapshot Level Table Application Dynamic SQL |
Logical Data Grouping table appl stmt subsection dynsql |
Monitor Switch Table Basic Basic Statement Statement |
|
Resettable |
Yes |
|
|
Event Type Connection Table Statement Transaction |
Logical Data Grouping conn_event table_event stmt_event xaction_event |
|
|
Element Name Element Type |
rows_written counter |
Description: This is the number of rows changed (inserted, deleted or updated) in the table.
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.