Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should you still tune queries by LIOs?

RE: Should you still tune queries by LIOs?

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Tue, 7 Sep 2004 12:48:42 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA312239757@EXCHANGE>


Well, here I have to disagree. You can set being well cached as the ultimate goal. That used to be the case for years and years. In the scientific literature, this methodology is known as "method C". (I assume that "C" stands for "Cary". I would really like to know why were methods named "C" and "R".) So, if your buffer cache hit ratio is over 95% and your shared pool hit ratio is over 99%, everything is peachy. User screams should be ignored or punished.

--
Mladen Gogala
A & E TV Network
Ext. 1216



> -----Original Message-----
> From: Dan Tow [mailto:dantow_at_singingsql.com]
> Sent: Tuesday, September 07, 2004 12:24 PM
> To: ryan_gaffuri_at_comcast.net
> Cc: oracle-l_at_freelists.org
> Subject: Re: Should you still tune queries by LIOs?
>
>
> There's no substitute for runtime as the ultimate target for
> minimization.
>
-- To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Tue Sep 07 2004 - 11:45:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US