ORA-01000: maximum open cursors exceeded hatasi

Error : ORA-01000: maximum open cursors exceeded

Cozum 

Open cursor sayisini artirmak

ALTER SYSTEM SET open_cursors = 5000 SCOPE=BOTH;

Default degeri 300 olmali

SQL> show parameter open_cursor;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------
open_cursors                         integer     300
SQL>