Have 12Gb RAM available , using parallel query with large mv joined to small code tables and setting session parameters to use Gb's of memory (have system to myself at the time) but system shows 12Gb RAM available still and writing to temporary segment - why or why or why?
Title: RE: set sort_area_size, sort_retained_size,hash_area_size but still writing to temp
- RE: set sort_area_size, sort_retained_size,hash_a... Paula_Stankus
- RE: set sort_area_size, sort_retained_size,h... Jack Silvey
- RE: set sort_area_size, sort_retained_size,h... Reardon, Bruce (CALBBAY)
- RE: set sort_area_size, sort_retained_size,h... Paula_Stankus
- RE: set sort_area_size, sort_retained_size,h... Jared . Still
