ORA-00018:maximum number of sessions exceeded解决方法

2014-11-24 14:07:27 · 作者: · 浏览: 1

ORA-00018:maximum number of sessions exceeded解决方法
原因:processes和sessions太小
解决方法:调大processes和sessions,一般sessions=processes * 1.1 +5
www.2cto.com
SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=335 scope=spfile;
SQL> shutdown immediate;
SQL> startup;