Automatic Shared Memory Management with Oracle 10g

Automatic Shared Memory Management (ASMM) was introduced with Oracle 10g. Its purpose is to automatically find the right size for

• shared pool
• large pool
• Java pool
• db buffer chache

Therefore, the respective init params java_pool_size, shared_pool_size, large_pool_size and db_cache_size need not be specified anymore.

Also, it seems that db_block_buffers can not be set anymore with ASMM enabled.

ASMM is enabled when sga_target is set to a value higher than 0 and when statistics_level is set to either typical or all

Automatic shared memory management is managed by the mman background process.