Internal Rows Deleted



Snapshot Level
Database
Application
 
Dynamic SQL


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_deleted
counter

 

Description:  This is the number of rows deleted 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 or triggers that you have defined on your database are necessary.

Internal delete activity can be a result of: