Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

i need to install/configure oracle jvm on 11g. to be able to install same i need to increase the size of shared_pool_size and java_pool_size. i have automatic memory management enabled. my sga_max_size = 512M. Can any one advise how to change the shared/java pool.

Thanks for the help.

share|improve this question

1 Answer 1

You're have AMM enabled, so Oracle will manage it for you automatically. SGA_TARGET will be set to a non-zero value, which means:

Specifies the total size of all SGA components. If SGA_TARGET is specified, then the buffer cache (DB_CACHE_SIZE), Java pool (JAVA_POOL_SIZE), large pool (LARGE_POOL_SIZE), and shared pool (SHARED_POOL_SIZE) memory pools are automatically sized.

You can set it to a non-zero value that is equal to or less than SGA_MAX_SIZE, so if you need to allocate more memory, just up SGA_MAX_SIZE and SGA_TARGET.

eg:

ALTER SYSTEM SET SGA_MAX_SIZE = 2048M;
ALTER SYSTEM SET SGA_TARGET = 2048M;

See this documentation section (search for "Enabling Automatic Shared Memory Management") - Read that whole documentation section to gain a better understanding.

As an aside, your SGA_MAX_SIZE does seem very small.

share|improve this answer
    
thnxs phill. so in my case where amm is enable, i dont need to increase shared memory and java memory? as for the sga_max_size, it should be less than the ram right? –  Shann Nov 14 '13 at 19:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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