Re: What cursors are open?

Refer to v$open_cursor.
The sid you need as foreign key is determined in v$session. To determine the sid of your own process use select sid from v$session where audsid=userenv('sessionid'). The user SYS doesn't have an audsid though.

Hth,

Sybrand Bakker, Oracle DBA

"Robert William Vesterman" <bob.work_at_vesterman.com> wrote in message news:39fde5b2.24706551_at_News.CIS.DFN.DE...
> Is there a way to tell who has what cursors defined, and opened?
>
> Something like "select * from user_tables", but for cursors?
>
> Thanks,
>
> Bob Vesterman.
Received on Mon Oct 30 2000 - 15:50:12 CST