Re: How many open Max Open Cursors?

From: Neill Atkins <natkins_at_uk.oracle.com>
Date: 1996/10/23
Message-ID: <01bbc037$a2facba0$4092038a_at_ukp2394.uk.oracle.com>#1/1


Isn't max open cursors limit of 255 a documentation error, the actual limit being a function of available SGA ?

George Haynes <GHAYNES_at_autover.nl> wrote in article <01bbbf86$4caab780$f9f64fc1_at_pppghaynesnlnet>...
> We use about 350, in V6 (early version) it was limited
> but later on upon advice of oracle we raised it above the
> limit and we didn't experience any negative effects.
> --
> George Haynes
>
> GHAYNES_at_autover.nl
>
> John Parrott <spo_at_interlog.com> wrote in article
> <32686AD6.6328_at_interlog.com>...
> > I realize that that this is a subjective kind of question but...
> >
> > What is an exceptable number for the Max Open Cursors parameter?
> >
> > I'm currently at 100 and I could use more.
>
>
Received on Wed Oct 23 1996 - 00:00:00 CEST

Original text of this message