IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: how to check maximum number of processes in oracle

ORA-00018: maximum number of sessions exceeded

Mehmet Salih Deveci April 7, 2020 ORA-ERRORS 0

Hi, Sometimes you can get ” ORA-00018: maximum number of sessions exceeded ” error.

ORA-00020: maximum number of processes exceeded and alter system set processes

Mehmet Salih Deveci June 28, 2019 ORA-ERRORS 1

Sometimes you may get ” ORA-00020: maximum number of processes exceeded ” error while login oracle database via sqlplus and Application may encounter TNS errors.