Oracle

Online Documentation

9.2
10.2
11.1

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;
Show constraints dependencies
select con.constraint_name, con.table_name, col.column_name, 
       ref.table_name as r_table, ref.column_name as r_column 
from all_constraints con, all_cons_columns col, all_cons_columns ref
where con.constraint_type = 'R'
and col.owner = con.owner and col.constraint_name = con.constraint_name
and ref.owner = con.owner and ref.constraint_name = con.r_constraint_name
and con.owner = 'owner' and ref.table_name = 'table';

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