Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ref Cursors Resultsets and ADO
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
>
>
--Received on Thu Aug 10 2000 - 00:00:00 CDT
> 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.