|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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 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