How to find Current open Cursors in Oracle
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 = 'opened cursors current';
from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9252210/viewspace-682012/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
