Oracle

v

Online Documentation

9.2
10.2
11.1

^ v

SQL

Open Cursor

Show number of open cursors
select b.name, a.value 
from   v$mystat a, v$statname b 
where  a.statistic# = b.statistic#
and    a.statistic# in (2,3);
Show open cursors
select user_name, status, osuser, machine, c.sql_text 
from   v$session b, v$open_cursor a,  V$SQLAREA c
where  a.sid = b.sid
and    c.address = a.address;

^ v


Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 License.