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 |
hash_join_overflows counter | |
Description: The number of times that hash join data exceeded the available sort heap space.
Usage: At the database level, if the percentage of "Hash Join Small Overflows" is greater than 10% of this value, then you should consider increasing the sort heap size. Values at the application level can be used to evaluate hash join performance for individual applications.