> silent about when the memory is returned to the OS. Is
> it when user session ends or at instance restart?.
When the session ends.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> Sort allocate memory in chunks of 8K,
Is that the general rule or does it depend on any
parameter?
> should worry only in case
> when there are too many users who are doing large
> sorts simultaniously. Also
> I think memory is freed when recor
I would make sort_area_retained_size = your average sort size. Otherwize
your sorts which are executed in memory will dump result after sorting into
temp tablespace and then server process will read it from there to return
rows. Sort allocate memory in chunks of 8K, so you should worry only in cas
Hi All,
Regarding Sorting.
In my database memory sort is 99% compared to disk
sorts. But the actual number of disk sorts are nearly
500 to 600 per week. This is a Data warehouse. I have
a few large fact tables ranging from (45GB to 10GB).
Some users do sort on the whole table. The top waits
are