Oracle中如何查看某个连接打开的游标数量

Maclean Liu(刘相兵

Question:

Oracle中如何查看某个连接打开的游标数量， (监控statement有没有关闭)

打开的游标，缓存的游标，

Maclean Liu(刘相兵

Answer:

请参考 Script:Diagnostic ORA-01000 maximum open cursors exceeded

http://www.oracledatabase12g.com ... rsors-exceeded.html

通过以下脚本 可以获得 某个连接打开的游标数量

select sum(a.value), b.name,a.sid
from v$sesstat a, v$statname b
where a.statistic# = b.statistic#
and b.name = 'opened cursors current'
group by rollup (b.name,a.sid)
order by 1
/

通过以下脚本 可以获得 某个连接 session cached cursor

select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#  and s.sid=a.sid
and b.name = 'session cursor cache count'
order by 1
/