Re: Shared Pool: Can it be filled *over* 100% ?

Mike Ault wrote:

> Jan,
>
> As I believe I said in my books,

If someone gets hold of a query of yours, it doesn't help much to say "buy my books to find out why it might not work". Which book? Which page number? Much easier just to comment the code itself, don't you think?

>the code can return greater than 100%
> due to the reason Jonathan states. Anyone who relies 100% on a GUI is
> not a real DBA in my opinion Omlet. You need to know the under lying
> tables and structures, then you might understand wha the GUI is
> telling you.

I couldn't agree more, actually. I like GUIs (I can't see why administering a database should give you RSI). But they are just a bunch of pretty pictures and potentially dangerous OK buttons unless you've already done the hard yards at the command line and know what they actually mean.  

> As to 15 years in a specific job making you beyond reproach, tell that
> to career politicians.
>
> I provide the script as a guideline, just to give people a heads up
> that their pool may be full of something besides useful code

That's always the danger, though, isn't it? A script intended as a guideline gets used instead as Gospel. It's what desperate users in need of a quick fix, or unwilling to think deeply, will always do. It's easier that way. It's why rules of thumb are inherently dangerous. It's why the offering of scripts *at all* is the real problem. Worked examples, with abundant caveats and cautions, yes. 'Run this to find out X', no.

>, the
> other two pieces of code that go along with it that actually show you
> how memory is being used and who is using it tell the whole story.
> This is just the patients temperature, as no good doctor would rely
> 100% on temperature as anything other than an indicator, this script
> should not be anything more than an indicator to check further.

Not a bad analogy, either.

> MIke Ault

Wonders will never cease. I find myself agreeing with you in large measure.

HJR Received on Sat Aug 14 2004 - 16:45:51 CDT