The presence of the "__" parameters suggests you are using either Automatic Shared Memory Management (ASMM) by setting the SGA_TARGET, or the Automatic Memory Management (AMM) by setting the MEMORY_TARGET parameter. These parameters hold the dynamic value of the relevant setting. You should not mess with them.
In both cases, Oracle controls all the cache and pool sizes. If the regular parameters are set, like DB_CACHE_SIZE, they act as minimum values, preventing the automatic configuration dropping that value. You can set these minimum values, or reset the parameter to blank it.
http://www.oracle-base.com/articles/10g ... managementhttp://www.oracle-base.com/articles/11g ... -11gr1.php
- Code: Select all
alter system reset param-name scope=both sid='mysid1';