Error: ORA-00020: maximum number of processes (string) exceeded Cause: All process state objects are in use. Action: Increase the value of the PROCESSES initialization parameter. Solution: You have to increase processes parameter value. ORA-00020 is caused by two things: 1- A lot of idle that is not working (zombie) connection. You can kill this connections…
Tag: ORA-00020
ORA-00018 maximum number of sessions exceeded
Error: ORA-00018 maximum number of sessions exceeded Cause: All session state objects are in use. Action: Increase the value of the SESSIONS initialization parameter. Solution: You have to increase processes and depends on this parameter which is sessions, transactions parameters. Calculating amount of sessions and transactions parameter values with below formula. processes=x sessions=x*1.1+5 transactions=sessions*1.1 You…