Oracle maximum open cursors.

select name, value from v$parameter where upper(name) in ('OPEN_CURSORS') order by name;

ALTER SYSTEM SET open_cursors = 3000 SCOPE=BOTH;

select name, value from v$parameter where upper(name) in ('OPEN_CURSORS') order by name;
    

Kopieren