Home » SQL & PL/SQL » SQL & PL/SQL » Open Cursors
Open Cursors [message #37685] Wed, 20 February 2002 22:21 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Creating a union of 3 views
Next Topic: substring
Goto Forum:
  


Current Time: Mon Sep 27 17:58:46 CDT 2021