i did what u suggested... i noticed that w/ every update,insert,delete i
made to different table remains in the
list of open cursors even though i commit after a updating a table. and
they will only be remove from the list if the program terminates. dml
commands uses implicit cursors. How could i remove/close those unwanted
open cursors from the list. is there a maximun for the max open cursor
option?
At 11:09 AM 11/24/00 +0100, you wrote:
>Hi!
>
>The commit;/ rollback; close the cursors.
>// but maybe it isn't good for you.
>
>select to check the opened cursors (system user):
>
>SELECT NVL(USERNAME,'ORACLE PROC')||'('||s.SID||')', SQL_TEXT
>FROM sys.V_$OPEN_CURSOR oc, sys.V_$SESSION s
>WHERE s.SADDR = oc.SADDR
>ORDER BY 1;
>
>That's all what I can send 2 you.
>Anti
>
>
>
>
>
>
>
>
Grace Lim
Suy Sing Comm'l Corp.
Received on Fri Nov 24 2000 - 21:48:12 CST
