Problem solve Get help with specific problems with your technologies, process and projects.

Completing processes without temp space

We have 16 GB of RAM on a test machine. We run some ETL processes, and it creates 12 GB of temp space used. We migrate that to a prod machine with 32 GB of RAM and run it. The process creates 12 GB of temp space used. How can we force processes to complete in memory, rather than using temp space? There are a number of different scripts at work, so I'm not asking for detailed analysis of our code, but rather the general question of how Oracle will allow all the stuff to happen without using temp space (given we have enough RAM).
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.