The memory for the SQL work area can also be controlled with the
SORT_AREA_SIZE initialization parameter.
Oracle does not recommend using the
The value of the
SORT_AREA_SIZE parameter should be set using the following rules:
You can also save time on index creating operations, or fast rebuilds, with on the fly statistics generation.
Example 13-5 is an example of setting the
A system with 512 Mb memory runs an Oracle instance with a 100 Mb SGA, and the operating system uses 50 Mb. The memory available for sorting is 362 Mb, which equals 512 minus 50 minus 100. If the system has four CPUs running with four parallel slaves, then each of these will have 90 Mb available. 10 Mb is set aside for process overhead, so
SORT_AREA_SIZE should be set to 80 Mb. This can be done either in the initialization file or for each session with the following statement:
ALTER SESSION SET SORT_AREA_SIZE = 80000000;
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1003456/，如需转载，请注明出处，否则将追究法律责任。