How to find out the Open Cursors ???
From: Bigfoot <ext6axp_at_ups.com>
Date: Mon, 5 Feb 2001 10:31:10 -0500
Message-ID: <95mh0c$c291_at_biko.telecom.ups.com>
Date: Mon, 5 Feb 2001 10:31:10 -0500
Message-ID: <95mh0c$c291_at_biko.telecom.ups.com>
Is there anyway to see how many explicit cursors opened for an
executable by querying any of the v$ tables.
I know the v$open_cursor list all the implicit and explicit cursors
opened during execution. But is there a way to differenciate what is
explict cursor and implicit cursor.
What I mean the explicit cursor is
( DECLARE
CURSOR emp_cur IS SELECT * FROM EMP;
BEGIN
OPEN emp_cur;
...
...
..
Received on Mon Feb 05 2001 - 16:31:10 CET