RE: More help on sort

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 11 Nov 2000 02:16:41 +1000
Message-Id: <10676.121716@fatcity.com>

Hi Frank,

If you set 'sort_area_retained_size' to 0, it will show as 0 in V$PARAMETER, but it defaults back to the value of 'sort_area_size' when called upon. You can confirm this with event 10032. However, if the sort occurs in memory, then this does not matter, because there is no merge phase in a memory sort.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Frank Marshall [mailto:frank.marshall_at_corp.usa.net] Sent: Saturday, 11 November 2000 0:27
To: Steve Adams; Raghunath, Shivaswamy; Multiple recipients of list ORACLE-L
Cc: answers_at_ixora.com.au
Subject: Re: More help on sort

What if the 'sort_area_retained_size' is set to 0. The sort occurs in memory and then what happens to the merge? Does the 0 setting for 'sort_area_retained_size' cause a write to disk? Received on Fri Nov 10 2000 - 10:16:41 CST