Re: OPEN_CURSORS

From: Ricq Pattay <patta003_at_tc.umn.edu>
Date: Thu, 7 Sep 2000 12:06:27 -0500
Message-ID: <8p8hp8$q8f$1@laurel.tc.umn.edu>

Is there a negative performance impact from increasing the number of open cursors?

---

Ricq Pattay <patta003_at_tc.umn.edu>
Univ of Minnesota - Twin Cities
College of Veterinary Medicine

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:967241565.8734.2.pluto.d4ee154e_at_news.demon.nl...
> Remarks embedded
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "kishen" <kishenp_at_my-deja.com> wrote in message
> news:8o6685$tub$1_at_nnrp1.deja.com...
> > Hi All,
> > Currently we have the OPEN_CURSORS set as default 50.
> > In some particular cases when certain SQL's are executed, 28-30 cursors
> > get openend. Due to which i get the maximum OPEN_CURSORS limit exceeded.
> > Is there a way to find out how many cursors get opened for a specific
> > SQL ?
>
> By design 1 per sql statement.
>
> Will increasing the number OPEN_CURSORS solve my problem ?
>
> Of course. 50 is way too low. Two hunderd is more like it and I usually
 set
> it to 500.
>
> >
> > TIA
> > Kishen
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Thu Sep 07 2000 - 12:06:27 CDT