Database Memory & 4030/4031 (MOSC)

MOSC Banner

How to increase the SGA?

edited Nov 5, 2009 3:27AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered
 Our AIX server currently is configured with large pages. Oracle is also configured to lock_sga. We have been able to bring up an instance up to 141296M. Any attempt to increase that value to take advance of additional 30 GB on the server produces errors.  We get ora-00064 Other parameters of interest

db_keep_cache_size                    big integer 49G
db_recycle_cache_size                big integer 8G
db_cache_size                             big integer 75G

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center