在初始化文件中的参数open_cursors中定义
open_cursors = 300SQL> show parameters open_cursors;NAME TYPE VALUE
------------------------------------ ------- ------------------------------
open_cursors integer 300
open_cursors = 300SQL> show parameters open_cursors;NAME TYPE VALUE
------------------------------------ ------- ------------------------------
open_cursors integer 300
sys.v_$open_cursorto get the current number of open cursors