By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.