Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: parameter file settings
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 - 12:41:45 CDT