Connect to the Oracle Database with SYS user through SQLPLUS

SQL> show parameter open_cursors;

NAME TYPE VALUE
———— —- ——–
open_cursors integer 300

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

Changed system.

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

Changed system.

SQL> show parameter open_cursors;

NAME TYPE VALUE
———— —- ——–
open_cursors integer 1000

Back to previous menu