Which memory settings affect querying?

Answer: For querying, you want to strive for a large system global area (SGA). You can set these SGA parameters in your Oracle Database initialization file. You can also set these parameters dynamically.

The SORT_AREA_SIZE parameter controls the memory that is available for sorting ORDER BY queries. You should increase the size of this parameter if you frequently order by structured columns.

See Also:

• Oracle Database Administrator’s Guide for more information on setting SGA related parameters

• Oracle Database Performance Tuning Guide for more information on memory allocation

• Oracle Database Reference for more information on setting the SORT_AREA_SIZE parameter