Hi Mark,
I'm curious with your procedure or script that using 'open (cursor);'
clauses.
please check whether you forgot to close the opening cursor. just a curious.
Rgrds,
Sony
-Original Message-
From: Mark Richard [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 6:14 AM
The max open cursors include necessary cursors to run direct sql submitted
by user and the cursors needed to run recursive sql by the system.
Regards,
Waleed
-Original Message-
Sent: Thursday, February 06, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
Hi,
We're currently
v$open_cursor doesn't reflect all cursors counting towards the max open
cursor limit. To see truly how many cursor each session is consuming
you need to associate v$sesstat with v$session and look at statistics#=3.
Richard Ji
-Original Message-
Sent: Thursday, February 06, 2003 7:39 PM
