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

Controlling process memory size in 9i

I had Oracle8i. Now I moved on to Oracle9i. When using Oracle9i, I found that it process consumes 1.5 times more non-shared memory than 8i. I have not used any specific features in 9i. I am using a same application earlier compiled with 8i. Is there a way to control process memory size in Oracle9i?
Look into Oracle9i's automatic memory management features. If the initialization parameter WORKAREA_SIZE_POLICY is set to AUTO, you can set the PGA_AGGREGATE_TARGET parameter to specify the total amount of memory that can be used by Oracle processes on your system. Oracle will automatically allocate this memory among processes that need it, depending on the operations they are performing. Oracle attempts to keep the amount of private memory below the target specified by this parameter.

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close