修改Oracle游标数及排查游标问题相关SQL

查看当前游标数
show parameter open_cursors;

修改游标最大数

alter system set open_cursors=1000;

commit;

查看游标消费情况

select o.sid, osuser, machine, count(*) num_curs

      from v$open_cursor o, v$session s

      where user_name = 'COSS' 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 = 683;