Internal Automatic Rebinds

 
Snapshot Level
Database
Application

 
Logical Data Grouping
dbase
appl

 
Monitor Switch
Basic
Basic

Resettable

Yes

Event Type
Database
Connection

Logical Data Grouping
db_event
conn_event

Element Name
Element Type

int_auto_rebinds
counter

Description:  The number of automatic rebinds (or recompiles) that have been attempted.

Usage:  Automatic rebinds are the internal binds the system performs when an package has been invalidated. The rebind is performed the first time that the database manager needs to execute an SQL statement from the package. For example, packages are invalidated when you:

• Drop an object, such as a table, view, or index, on which the plan is dependent

• Add or drop a foreign key

• Revoke object privileges on which the plan is dependent.

You can use this element to determine the level of database activity at the application or database level. Since internal automatic rebinds can have a significant impact on performance, they should be minimized where possible.

You can also use this element to determine the percentage of rebind activity using the following formula:

 
 internal automatic rebinds / total number of statements

This information can be useful for analyzing application activity and throughput.