oracle默认的游标数是300,最大的话应该是1000.
查看当前最大游标数:
SQL> show parameter open_cursors;
NAME
TYPE <a href=
"https://www.baidu.com/s?wd=VALUE&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y4P16zn1NhnHTzP1w9uAf10ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnW0LPHD1n1RYP1mYPjDYnWczr0"
target=
"_blank"
class=
"baidu-highlight"
>VALUE</a>
------------------------------------ ----------- -------------------
open_cursors
integer
300
|
设置最大游标数的命令:
SQL>
alter
system
set
open_cursors=1000 scope=both;