Oracle modifies session, processes, and oracleprocesses

Oracle modifies session, processes, and oracleprocesses
1. Check the values of the two parameters sqlplus/nologsql> conn/as sysdbasql> select count (*) from v $ session; here we can see the current session count SQL> select count (*) from v $ process; here we can see the current number of processes
SQL> show parameter processes; the value of processes in the current database can be seen from the output information. SQL> show parameter sessions; the value of sessions in the current database can be seen from the output information.

If the number of Session connections exceeds the preceding processes or sessions, a 12516 error occurs. You can modify the value as follows:

Sessions = 1.1 * processes + 5; // This is the relationship between the sessions value and the processes value. It is best to follow this process,

Therefore, to set the number of processes to 500, the number of sessions must be 1.1*500 + 5 = 555

2. Modify the values of these two parameters.

SQL> alter system set processes = 500 scope = spfile;
SQL> alter system set sessions = 555 scope = spfile;

3. Restart the Database Service to make these two parameters take effect.

SQL> shutdown immediate

SQL> startup