Check status

select name, value from v$parameter where name in ('processes', 'sessions', 'transactions');

--------------------------------------------------------------------------------
processes
150
sessions
248
transactions
272

 

Increase

sqlplus / as sysdba
alter system set processes = 1000 scope = spfile;
alter system set sessions = 1524 scope = spfile;
alter system set transactions = 1676 scope = spfile;
shutdown immediate;
startup;
  • No labels

Site may be often unavailable due to Russian invasion, but you can Help Ukraine