are there really that many people who use hit ratio?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/12/23 Tue AM 11:49:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Hit Ratio
Yong,
Connor's script is not a joke, it's a proof by counterexample that the
I hope not, but I think so.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original
Cary's being diplomatic, as well as engaging in some wishful thinking.
:)
They appear to be quite prevalent. There are other microcosms of
Oracle users that you will find from time to time that realize
how Oracle works, and how to go about fixing performance problems.
If though you consider
Jared,
I'm going to take some exception to what Cary has said on the subject, but I
believe in the end she'll agree with me.
LIO's are inherently cheaper than PIO's simply because you have to complete
the LIO before asking for a PIO. And no you can't work with data that has
At 12:04 23-12-03 -0800, you wrote:
Jared,
I'm going to take some exception to what Cary has said on the
subject, but I believe in the end she'll agree with me.
She? Cary, you didn't tell us about this surgery ;-)
Dick, last time I saw Cary (October) he was very masculin. I bet this
SORRY!! Regrettably e-mail does not provide the required info, namely a picture. The
only other Cary I know is female, in every sense of the word.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, December 23, 2003 3:45 PM
To: Multiple recipients
immature ...and all this time I thought Cary was a man! :)
...now all the talk of showers and Cary's cleanliness from Mogens makes
sense!!
...(I'm 99.99% sure Cary IS a man...at least he looked it at IOUG a few
years back) :)
/immature
merry xmas everyone!
-Original Message-
Sent:
Why do people still talk about THE
buffer cache hit ratio ? There are lots
of them.
The one you can get from v$sysstat,
the ones you can get from v$buffer_pool_statistics,
and the ones you can get from v$segstat.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is
Exactly.
select * from v$statname where name like '%gets%'
is simple evidence of that.
Cheers
Connor
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
Why do people still talk about THE
buffer cache hit ratio ? There are lots
of them.
The one you can get from v$sysstat,
the ones you can
i dont think many people are using bchr anymore. I think its been talked down to
death. only place I hear about it is offshore. people still using the old niemic book.
his new took all that stuff out.
or am i wrong?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/12/22 Mon PM 02:14:26 EST
CLASSIFICATION: UNCLASSIFIED
Rich,
Burn any source that talks about hit ratio's.
What exactly is running slow in your system and at what times ?
Talk directly to the user that is experiencing the slowdown and ask them
to repeat the behavior.
Set a 10046 trace and go find the slowdown while
Erm...sorry. I said :) when I should've said ;). Joke. Pun.
Tongue-in-cheek. Yer built too low. The fast ones keep going over
your head. Gotta keep your eye on the ball. Eye. Ball. That's
a joke there, son.
Again, sorry. We're in no change mode until after the Holidaze and
Foghorn
Rich,
you mean due to 'no change mode' you can't even change your hit ratio ... too bad.
Happy holidays everyone !!
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
13 matches
Mail list logo