1、查看ORACLE最大游标数
C:\Documents and Settings\Administrator>sqlplus "sys/orcl@orcl as sysdba"
SQL> show parameter open_cursors;
NAME TYPE VALUE
----------------------------------- ----------- ------------------------------
open_cursors integer 300
2、查看当前打开的游标数目
SQL> select count(*) from v$open_cursor;
----------
17494
3、修改ORACLE最大游标数
SQL> alter system set open_cursors=1000 scope=both;
系统已更改。
SQL> show parameter open_cursors;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000
C:\Documents and Settings\Administrator>sqlplus "sys/orcl@orcl as sysdba"
SQL> show parameter open_cursors;
NAME TYPE VALUE
----------------------------------- ----------- ------------------------------
open_cursors integer 300
2、查看当前打开的游标数目
SQL> select count(*) from v$open_cursor;
----------
17494
3、修改ORACLE最大游标数
SQL> alter system set open_cursors=1000 scope=both;
系统已更改。
SQL> show parameter open_cursors;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000