Sometimes you can get ” ORA-00018: maximum number of sessions exceeded ” error.
Details of error are as follows.
ORA-00018: maximum number of sessions exceeded Cause: An operation requested a resource that was unavailable. The maximum number of sessions is specified by the initialization parameter SESSIONS. When this maximum is reached, no more requests are processed. Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the SESSIONS parameter in the initialization parameter file, and restart Oracle.
processes=x sessions=x*1.2 transactions=sessions*1.2
SQL> alter system set processes=1000 scope=spfile; SQL> alter system set sessions=1200 scope=spfile; SQL> alter system set transactions=1440 scope=spfile; SQL> shutdown immediate SQL> startup
Do you want to learn Oracle Database for Beginners, then read the following articles.
293 views last month, 7 views today