数据库无法启动:

ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 3170893824 cannot be set to more than MEMORY_TARGET 1610612736.

解决方法:
start force

 

参考相关命令:

show parameter target;

alter system set sga_target=3000m scope=spfile;

shutdown immediate;

startup;

alter system set processes=420 scope = spfile;

show parameter processes;
show parameter sessions;

 

sessions 与process关系:
(sessions=(1.1*process+5))


版权声明:本文为giveupyou原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
原文链接:https://blog.csdn.net/giveupyou/article/details/84708652