Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Max Open Cursors

Re: Max Open Cursors

From: Kanv <kanvpandit_at_hotmail.com>
Date: 8 Apr 2003 04:54:10 -0700
Message-ID: <2554c5c7.0304080354.4648609@posting.google.com>


"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:<VPJja.338660$L1.96043_at_sccrnsc02>...
> George,
> If you are using PL/SQL then fine with implicit cursors. They will get
> closed upon exit of the procedure or function. If you are using an api (eg
> oci, odbc, ado, jdbc, etc.) then you need to either:
> 1. Open a cursor once and reuse it for the life of an application. (using
> bind variables this is a very efficient method; you rebind and reexecute
> when your bind variable values change)
> or
> 2. Close the cursor when you are done.
>
>
> You probably have a leak in your application - opening a cursor again and
> again, whereas if you opened it once and rebound the bind variables you
> would be all set. If you aren't using bind varibles then you are
> signifigantly hurting your performance and scalability.(and need to close
> the cursor every time)
>
> I would get off 8.05 asap and go to at least 8.1.7.4 or later.
>
> Jim

Would vote on what Jim says on the leak in your app. Nine out of ten times have seen that to be the cause of the open cursors exceeded available. Any particular reason why you wouldnt increase the 900 value? Received on Tue Apr 08 2003 - 06:54:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US