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/