Tag Archives: cursors

Change Number of Oracle Cursors

Change Number of Oracle Cursors

 

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