I have explored all that it is available from metalink (that I could find) and various books. Anyone know where there is a good comprehensive explanation of sortings/sorts/temporary segments/sorting and buffer cache in one place/document?
-----Original Message-----
From: Stankus, Paula G
Sent: Thursday, June 13, 2002 10:20 AM
To: '[EMAIL PROTECTED]'
Subject: RE: set sort_area_size, sort_retained_size,hash_area_size but
still writing to temp
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?
