Re: Temp Tablespace

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 Jun 1999 21:36:24 +0100
Message-ID: <928961627.26673.3.nnrp-07.9e984b29@news.demon.co.uk>

Could you expand on 'a nested statement' - In theory there is 'only one memory area of SORT_AREA_SIZE for each user process at any time' (oracle 8.0 reference p1-114).

Multiple areas of size sort_area_size went out with version 6 (according to the manuals), but I have always been a little suspicious of how strictly Oracle sticks to their description of SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE, after all, the manual says that multiple areas of size sort_area_retained_size will be allocated for multiple concurrent sorts - so what happens if you set both parameters to the same size ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Rniemic wrote in message <19990607134052.24858.00000012_at_ng34.aol.com>...
>Also, if you have a nested statement requiring TWO sorts, each will use the
>value of the sort_area_size potentially using more memory than you
expected.
>Hope that helps... If this is still unclear...I wrote it fast...send me a
>message on the unclear part.
Received on Wed Jun 09 1999 - 15:36:24 CDT