数据库无法启动:
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))