Oracle uses temporary space for a few operations such as sorting, performing hash joins, and creating bitmap indexes. The amount of sort space that each Oracle process can use in memory is determined by the SORT_AREA_SIZE, HASH_AREA_SIZE, and CREATE_BITMAP_AREA_SIZE parameters. In Oracle 9i, the new PGA_AGGREGATE_TARGET parameter takes the place of all of these. To increase the amount of space that Oracle can use in memory, before using disk space as staging areas for the work, increase the appropriate INIT.ORA parameter.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.