ORA-01000 maximum open cursors exceeded

Hi,

You can get ” ora-01000 maximum open cursors exceeded ” error during the database operation.

If you got this error, it means you have reached the open cursor limit.

Check current value of open_cursor parameter.

SQL> show parameter open_cursors

NAME TYPE VALUE
———————————— ———– ——————————
open_cursors integer 300
SQL>
SQL>

Modify current value of open_cursor parameter, you can change the value according to your resource and database.

SQL> alter system set open_cursors=1000 scope=both;

System altered.

Check it again, parameters are changed.

SQL> show parameter open_cursors

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

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/