Re: parameter file settings

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 8 Jun 1999 18:51:55 -0400
Message-ID: <teh73.492$Qt.11227@typ22b.nn.bcandid.com>

Open cursors is the number of cursors you can have open in a session. There is no penalty for setting this parameter high and not using all the cursors you specified.

Van

<farrellyr_at_my-deja.com> wrote in message news:7jjkkn$rcb$1_at_nnrp1.deja.com...
> In article <7jjf1l$org$1_at_nnrp1.deja.com>,
> ngroves_at_ndsuk.com wrote:
> > In article <7jjcec$nku$1_at_nnrp1.deja.com>,
> > farrellyr_at_my-deja.com wrote:
> > > We have a fairly new database, and I have received an error in
> regards
> > > to the open_cursors. I have increased them, but I was wondering how
> > > would I go about setting this number if I were setting it for the
> > first
> > > time?
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Share what you know. Learn what you don't.
> > >
> > Depends on the types of activity against your database.
> >
> > On my development database I've got it set to 2400 - team of 30ish
> > developers, some working with a cursor hungry product called Magic - &
> > on my testing database 4800 - simulated hundreds of users.
> >
> > Don't know if these figures are high or low in relation to other DBA's
> > - I just know they work for me.
> >
> > Guess it boils down to experience...
> >
> > Regards
> >
> > Nigel Groves
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.

>

> Is anything affected if I set it too high? From what I have read
> setting it too high doesn't hurt, I just want to make sure. I thought
> that this number is used for each user. So your 30 users can have 2400
> each, is that correct, it doesn't sound right to me now?

>

> Thanks alot.
> >

>
>

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
> Received on Tue Jun 08 1999 - 17:51:55 CDT