Q

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.
This was first published in November 2003
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close