I thought if I set workarea_size_policy = AUTO, Oracle will simply
ignore all my SORT_* parameters?
> If the sorts to disk bother you, set SORT_AREA_SIZE to a value to
> specify the smallest maximum amount of memory that can be used during a
> single sort - Oracle can automatically use more memory than what is
> specified. Care must be taken if you chose to specify SORT_AREA_SIZE,
> if there are many sessions that will be connected to the database at
> the same time.
Received on Tue Jan 23 2007 - 19:59:52 CST
