Re: Open Cursors

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 3 May 1999 18:38:46 +0200
Message-ID: <925749389.27012.0.rover.d4ee154e@news.demon.nl>

Yes refer to the v$open_cursor dictionary view. You will need the sid of the session. Of one the ways to get it is select sid from v$session where audsid = userenv('sessionid')

alternatively you could use v$sqlarea

Hth,

Sybrand Bakker, Oracle DBA

Douglas Whitacre wrote in message <7gkbf4$92m_at_world1.bellatlantic.net>...
>Is there a way to track open cursors either for a session or in general?
>
>Thanks in advance.
>
>
Received on Mon May 03 1999 - 11:38:46 CDT