Re: Sizing SHARED_POOL_SIZE

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> Howard,
>
> Hmmm... I thought you were going to use it to size your production
> shared pool -:)
>
> Yes I agree with you that it definitely is not gospel and other
> factors should be considered, specially when sizing production. I have
> had this script in my archive for a while and couldn't resist posting
> it after reading the subject. I do however use it once in while by
> running it at different times of a day just to get an average shared
> pool requirement as it relates to fluctuating number of concurrent
> users.

As I said, I wasn't having a go at you, and I was rather impressed with script (was it one you wrote yourself?). It is most definitely a starting point when you haven't the faintest idea what to set s_p_s to initially, that's for sure.

>
> I guess it would be a "DBA state of nirvana" if one can perfectly size
> all init.ora parameters by just running one script!!!
Received on Thu Jan 16 2003 - 02:16:08 CST