Re: parameter file settings

However, if someone runs away with cursors, keep in mind they do take memory resources and overhead. This parameter is more for safety I think.

• Dc.

Van Messner wrote:

> 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 Wed Jun 09 1999 - 17:14:34 CDT