###2、确认没有启用AMM,因为AMM和lock_sga不兼容 set linesize 100 col name format a30 col value format a30 select name,value from v$system_parameter where name in ('memory_target','memory_max_target','lock_sga');
NAME VALUE ------------------------------ ------------------------------ lock_sga TRUE memory_target 0 memory_max_target 0
---如果AMM参数或者lock_sga设置不符合要求,可以按照如下步骤重设 SQL> alter system reset memory_max_target;