Re: Sizing SHARED_POOL_SIZE

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<tJtV9.25258$jM5.66991_at_newsfeeds.bigpond.com>...
> 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.
>

It's one of those "hand-me-down" scripts. I got it from a friend couple of years ago and he got it from someone else and so on. Not sure who the original author is. However, I did tweaked it a bit to make it work in our env.

Like I said before, it is usefull when run periodically just to gauge the impact of fluctuating users on shared_pool_size + as you mentioned...someone who is just starting out can use it as a starting point.

Regards
/Rauf Sarwar Received on Thu Jan 16 2003 - 14:03:00 CST