系统运行了一段时间报错:java.sql.SQLException: ORA-01000: 超出打开游标的最大数
查看数据库当前的游标数配置sqlplus:show parameter open_cursors;
查看游标使用情况:
select o.sid, osuser, machine, count(*) num_curs
from v$open_cursor o, v$session s
where user_name = 'user ' and o.sid=s.sid
group by o.sid, osuser, machine
order by num_curs desc;
查看游标执行的sql情况:
select q.sql_text
from v$open_cursor o, v$sql q
where q.hash_value=o.hash_value and o.sid = 123;