Thursday, March 15, 2007

Ratios redux

I have got myself embroiled with Don Burleson in another OTN forum thread on cache hit ratios. In it he asks me
'Surely, you don;t(sic) mean that you would dismiss something because it's "not always relevant"?

If it applied on only 5% of the cases, it's still useful then, right?'

I think we can quibble for ever over the usefulness of a metric that is not applicable in 95% of cases. Of course we can use our skill and judgement to evaluate the importance of a low cache hit ratio is meaningful. But how much investigation is required to determine whether it matters? Is that the best use of our time? In most tuning situations I come across these days it doesn't seem relevant. YMMV (Don's obviously does).

Funnily enough one of the other threads I mentioned in my previous article demonstrated a situation where a low cache hit ratio was indeed an indicator of a bad situation. When the OP finally posted the relevant init.ora parameters we discovered

buffer cache size = 32 mb
shared pool = 76 mb

As Laurent Schneider observed, that's barely enough memory for a pocket calculator.


Blogger Laurent Schneider said...

I had a good laugh on the script from 3360 ! Quite useful for to fulfill your SLA ;-)

15 March 2007 at 13:55:00 GMT-7  
Blogger APC said...

Yeah, I like Connor's script too, I've been pointing people to it for years. If you ever get the chance see Connor present do grab it. He is a very entertaining presenter

Cheers, APC

16 March 2007 at 00:55:00 GMT-7  
Blogger Laurent Schneider said...

ROFL, poor poor poor squirrel

16 March 2007 at 04:39:00 GMT-7  
Blogger Joel Garry said...

This is why the first thing I do on a new-to-me system is just poke about and see if it looks like some newbie accepted all the defaults or something. I can't see why people throw all sorts of advice like use method-r or bhcp or statspacks at someone who hasn't even got the system to a reasonable starting point. You ought to be clued in when someone doesn't know how to show or change init.ora parameters... talk about low-hanging fruit...

word: gfewz

19 March 2007 at 11:23:00 GMT-7  
Anonymous shoe stretchers said...

If you were going to buy a golf club, you wouldn't walk into a store and buy the first one you see, would you? Of course

not; especially if you want to improve your golf game! You'll want to hold the club, take some practice swings, hit some

balls if the store has a practice spot, and look at the price, of course. If you are considering buying running shoes,

you need to go through a similar process and take the time to find the perfect shoe.

20 March 2007 at 00:35:00 GMT-7  
Blogger Laurent Schneider said...

I think the comment above is a spam

20 March 2007 at 12:41:00 GMT-7  
Anonymous car amplifier said...

A car amplifier will give you a loud and clear sound on a consistent basis. It will boost the power flowing from the

receiver to the speakers. In doing so, it will reduce the stress put on all the other components of your car stereo

system, including the receiver.

Choosing the right car amplifier is important. Your decision should be based on five important features. Make sure you

address them all !

The first item on the agenda is the number of channels. This will depend on the number of speakers in your system.

Two-channel amplifiers will feed well two speakers or a single subwoofer. You will want to consider a four-channel

amplifier if you have any of the following combinations :

25 March 2007 at 03:52:00 GMT-7  
Anonymous Anonymous said...



11 October 2008 at 10:04:00 GMT-7  
Blogger Jerry said...

cheap wedding gowns
discount bridal gowns
China wedding dresses
discount designer wedding dresses
China wedding online store
plus size wedding dresses
cheap informal wedding dresses
junior bridesmaid dresses
cheap bridesmaid dresses
maternity bridesmaid dresses
discount flower girl gowns
cheap prom dresses
party dresses
evening dresses
mother of the bride dresses
special occasion dresses
cheap quinceanera dresses
hot red wedding dresses

18 June 2009 at 09:17:00 GMT-7  

Post a Comment

<< Home