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 |
total_hash_joins counter | |
Description: The total number of hash joins executed.
Usage: At the database or application level, use this value in conjunction with "Hash Join Overflows" and "Hash Join Small Overflows" to determine if a significant percentage of hash joins would benefit from modest increases in the sort heap size.