0

I have a linux server (rhel4) with oracle 9i (9.2.0.8) to which we have recently upgraded the RAM memory from 4G to 16G. I would like to know what server parameters I should modify and even more what Oracle parameters should I modify to make use of this new configuration from memory, thank you very much for your answers.

0

1 Answer 1

2

In 9i, multiple parameters are used for sizing components of the SGA. Below is a typical (but not complete) list:

DB_CACHE_SIZE

JAVA_POOL_SIZE

LARGE_POOL_SIZE

SHARED_POOL_SIZE

And SGA_MAX_SIZE, if set.

Also I assume for simplicity that you use automatic PGA management, so for PGA:

PGA_AGGREGATE_TARGET

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.