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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.



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


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.