Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sort operations
Alexander,
> As for Special Edition Using Oracle8, in Chapter 31 it says following
> statements:
>
> 'The two primary init.ora parameters affecting sort operations are
>
> SORT_AREA_RETAINED: The maximum amount of memory to be used for an
> in-memory sort
> SORT_AREA_SIZE: The maximum amount of memory to be used for an
> external disk sort
> operation, involving the allocation of a temporary segment
This is wrong. The SORT_AREA_SIZE controls the maximum amount of memory allocated to an in-memory sort. If the sort exceeds this size, then the sort is broken into smaller pieces and sorted (at least partially) on disk. I'd trust the Oracle documentation before Special Edition.
HTH,
Brian