After Sort what?

From: Pradeep <agarwalp_at_eeism.com>
Date: 29 Nov 2005 08:45:10 -0800
Message-ID: <1133282710.253507.177490@f14g2000cwb.googlegroups.com>

The docs states that
" Sort_area_size is the memory used to for sort." This is understood

What i don't understand 1005 is the below

"After the sort is complete, but before the rows are returned, Oracle
releases all of the memory allocated for the sort, except the amount specified by the
SORT_AREA_RETAINED_SIZE parameter. After the last row is returned, Oracle
releases the remainder of the memory."

Q1. <<After the sort is complete, but before the rows are returned, Oracle
releases all of the memory allocated for the sort>> I really don't get this. What happens to the sorted rows? How does it provides the sorted rows ?

Q2. what does SORT_AREA_RETAINED_SIZE? does it stores some of the sorted rows or what?

Please clarify? Received on Tue Nov 29 2005 - 10:45:10 CST