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_small_overflows counter | |
Description: The number of times that hash join data exceeded the available sort heap space by less than 10%.
Usage: If this value and "Hash Join Overflows" are high, then you should consider increasing the sort heap threshold. If this value is greater than 10% of "Hash Join Overflows", then you should consider increasing the sort heap size.