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

Memory allocation for better Oracle performance

My question is regarding the memory allocation for Oracle 10g on HP Itanium server having RAM of 8GB. How much memory should I allocate to DB_CACHE_SIZE, LARGE_POOL_SIZE, SHARED_POOL_SIZE, SORT_AREA_SIZE and PGA_AGGREGATE_TARGET for better performance? I am using the InterMedia utility and a table with a CLOB field. The db_block_size is 8 KB.

My question is regarding the memory allocation for Oracle 10g on HP Itanium server having RAM of 8GB. How much memory should I allocate to DB_CACHE_SIZE, LARGE_POOL_SIZE, SHARED_POOL_SIZE, SORT_AREA_SIZE and PGA_AGGREGATE_TARGET for better performance? I am using the InterMedia utility and a table with a CLOB field. The db_block_size is 8 KB.
My advice would be to take advantage of Oracle10g's ability to allocate SGA memory among the various components by specifying a value for SGA_TARGET. I would suggest setting SGA_MAX_SIZE to about 5 GB for starters and setting SGA_TARGET to 4GB. Run the system under load for a time and observe how much memory is provided to the various SGA areas. You can always reduce SGA_MAX_SIZE and/or SGA_TARGET if there is pressure on system memory.

The best value for PGA_AGGREGATE_TARGET will depend on the number of concurrent sessions. I generally start out...

with a value of about 200 MB and then use the advice provided in Enterprise Manager to adjust the value up or down.

This was last published in January 2006

Dig Deeper on Oracle database performance problems and tuning

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close