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';
How to find Current open Cursors in Oracle
-
zhanglei_itput
2010-12-17 10:52:09 -
Linux操作系统
- 原创
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';