Home » RDBMS Server » Performance Tuning » Need some help resizing SGA parameters
Need some help resizing SGA parameters [message #124740] Tue, 21 June 2005 03:44 Go to next message
prestoj8
Messages: 5
Registered: May 2005
Junior Member
Dear All

I need to resize the following SGA parameters, can someone please provide a list of steps of how to go about it?

I know some of them can be done dynamically while the instance is running. I need to know how to do it when the instance is shut down.


current set value(MB) New value (MB)
JAVA_POOL_SIZE 160 0
SHARED_POOL_SIZE 160 128
DB_CACHE_SIZE 32 500
LARGE_POOL_SIZE 16 16

Using Oracle9i 9.2.0.6

Regards

Prestoj8



Re: Need some help resizing SGA parameters [message #124747 is a reply to message #124740] Tue, 21 June 2005 04:09 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
When DB is down, change these parameters in init.ora file. Startup the database using this file & then recreate the spfile when the DB gets started.
Previous Topic: Reg. Performance Issue with XML
Next Topic: How to increase Performance of Composite Primary Key
Goto Forum:
  


Current Time: Wed Jan 27 14:39:45 CST 2021