Then what is sort_area_retained_size for ?
TIA
- Original Message -----
From: "John Kanagaraj" <JKanagaraj_at_mfi.com>
To: "oracle dba list" <oracledba_at_lazydba.com>
Sent: Monday, November 27, 2000 8:17 PM
Subject: Re: Ixora News - November 2000 - Sort memory
> > Oracle does not attempt to free unused heap memory to Unix at all. What
I said
> > was, "Once the last row has been fetched, all sort memory is released to
UGA
> > heap, and most of it is then immediately released to its parent heap
(the PGA,
> > or SGA in MTS connections). Free/unused PGA memory will be readily paged
out by
> > the operating system under memory pressure." That is, the free memory
remains in
> > the PGA. Oracle relies on the operating system to page out unused PGA
memory if
> > necessary.
>
> Hi Jay,
>
> May I also add that paging space will NOT be released until the process
> exits, so if you have persistent connections with large (but now unused)
> sort memory, then you could potentially need a *lot* of swap space...
>
> --
> John Kanagaraj
> http://www.geocities.com/john_sharmila
>
> Disclaimer : The opinions expressed above are my own and do
> not reflect those of MFI or its associates
>
> --------
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Received on Tue Nov 28 2000 - 06:56:31 CST
