查看游标方法

1、--统计游标总数
select o.sid, osuser, PROCESS,PROGRAM, count(*) num_curs
from v$open_cursor o, v$session s
where osuser='lzm' and user_name = 'ZHZW' and o.sid=s.sid 
group by o.sid, osuser, PROCESS,PROGRAM
order by  num_curs desc

2、--查看某个程序的所有游标语句
select SQL_TEXT
from v$open_cursor o, v$session s
where user_name = 'ZHZW' and o.sid=s.sid 
and PROCESS='2146392'

3、--知道某一特定sql查询打开的游标数
select a.sql_text, a.sql_id, b.count, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from v$sqlarea a, 
(select sql_id, count(*) count from v$open_cursor group by sql_id) b 
where a.sql_text like 'select integralcyc%' and a.sql_id = b.sql_id;

4、根据程序名查询打开的游标数
select p.SQL_TEXT,count(*) ,sysdate from v$session s ,V$OPEN_CURSOR p 
where s.SID=p.SID and s.program like'Date%' group by p.SQL_TEXT order by p.SQL_TEXT;