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: Ref Cursors Resultsets and ADO

Re: Ref Cursors Resultsets and ADO

From: Örjan Lundberg <oluies_at_my-deja.com>
Date: 2000/08/10
Message-ID: <8mtqt4$7e3$1@nnrp1.deja.com>#1/1

Try setting thease in init*.ora:

open_cursors = 300
SESSION_CACHED_CURSORS=30 (I can't back these number up by facts, please comment.)

In article <8mtpfs$dbg$1_at_kermit.esat.net>,   "Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote:
> I currently have tested returning a resultset from ADO
> (both 2.1 and 2.5) , using a stored procedure returning a Ref Cursor.
>
> After the procedure is called 50 times, an Oracel error is returned
 (Two
> many open cursors).
>
> The max no of open cursors is set to 50 in my Database (probably the
> Default).
>
> Presumably this is beacuse ADO does not close the cursor.
> Is there anything I can do on the server side to overcome this
 limitation. I
> sit possible to close a ref cursor if it is open.
> What is the potential impact.
> What is a sensible no of open cursors to have for a 350 user system
>
> TIA
>
>

--

> Help the needing:
> http://www.hungersite.com/
> http://rainforest.care2.com/front.html/7730d1620ebab18d
Sent via Deja.com http://www.deja.com/ Before you buy.
Received on Thu Aug 10 2000 - 00:00:00 CDT

Original text of this message

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