Open Cursors [message #37685] |
Wed, 20 February 2002 22:21 |
Prabath Kuga gamage
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
Hello Everybody
We have a application with many PL/SQL stored packages.
Some time we experienced a ' Too Many Open Cursor' error.
Do you have any idea about how to trace Open Cursor at runtime?. Is there is facility in DBA to trap this?
Regards
Prabath
|
|
|
Re: Open Cursors [message #37690 is a reply to message #37685] |
Thu, 21 February 2002 06:51 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
try to increase open_cursors parameter value.
if it is set to reasonable number then review code.(there is a possibility of not closing cursors in programs).
query v$open_cursor view
|
|
|
Re: Open Cursors [message #37695 is a reply to message #37685] |
Thu, 21 February 2002 17:28 |
Prabath Kuga gamage
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
Thanks Suresh for your input.
The Cursors listed in V$Open_Cursors are always open, Even though we have CLOSED the Cursors, they are still cached in Server memory.
Before Oracle8 release we had a parameter called CLOSE_CACHED_Open_Cursors in init.ora which forces all of these cached Cursors to be closed at the end of each transaction,
But with the Oracle 8 this Paramaeter has been obsoleted.
So that I suppose V$Open_Cursors can not be used to check still Open Cursors at Runtime?
Your comments.....
cheers
prabath.
|
|
|