|
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:
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.