1、查看Oracle最大游标数SQL> show parameter open_cursors; NAME TYPE VALUE ------------------------------------ ----------- ------------------- open_cursors integer 3002、查看当前打开的游标数目SQL> select count(*) from v$open_cursor; COUNT(*) ---------- 174943、修改Oracle最大游标数SQL> alter system set open_cursors=1000 scope=both; 系统已更改。SQL> show parameter open_cursors; NAME TYPE VALUE ------------------------------------ ----------- -------------------- open_cursors integer 1000
------------------------------------ ----------- -------------------
open_cursors integer 3002、查看当前打开的游标数目SQL> select count(*) from v$open_cursor;
COUNT(*)
----------
174943、修改Oracle最大游标数SQL> alter system set open_cursors=1000 scope=both; 系统已更改。SQL> show parameter open_cursors; NAME TYPE VALUE
------------------------------------ ----------- --------------------
open_cursors integer 1000