Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cache Hit Ratio from system views
Bob Jones wrote:
>> To quote the Oracle docs: >> "A low cache hit ratio does not imply that increasing the size of the >> cache would be beneficial for performance. A good cache hit ratio could >> wrongly indicate that the cache is adequately sized for the workload." >>
You have been challenged repeatedly to put up a test case that supports your position. Either you don't have SQL*Plus or don't know how to use it? I wonder which?
You are in no position to criticize anyone or anything. Especially Oracle docs for vagueness. So far the only thing you've done with clarity is define your lack of expertise on the subject.
>> BHCR is as worthless as your unwillingness to acknowledge you are wrong.
No. You should take it that he doesn't use worthless metrics to do so.
>> But given that your name is in valid, and your email is not valid, why >> would anyone expect your opinion to be valid? Come on out of the closet.
Wrong again: You have neither.
I wonder ... why would someone at San Diego State be so afraid to acknowledge who they are? Perhaps some more research will answer that question.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Sep 07 2007 - 19:13:58 CDT