Internal Rows Updated

 
Snapshot Level
Database
Application
 
Statement

 
Logical Data Grouping
dbase
appl
stmt
dynsql

 
Monitor Switch
Basic
Basic
Basic
Statement

Resettable

Yes

 
Event Type
Database
Connection
Statement

 
Logical Data Grouping
db_event
conn_event
stmt_event

Element Name
Element Type

int_rows_updated
counter

Description:  This is the number of rows updated from the database as a result of internal activity.

Usage:  This element can help you gain insight into internal activity within the database manager of which you might not be aware. If this activity is high, you may want to evaluate your table design to determine if the referential constraints that you have defined on your database are necessary.

Internal update activity can be a result of:

• A set null row update enforcing a referential constraint defined with the ON DELETE SET NULL rule
• A trigger being fired.