RE: Should you still tune queries by LIOs?
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- Date: Tue, 7 Sep 2004 12:01:59 -0500
Agreed. Using runtime as the target has caused us to get to the point where
simple queries were no longer acceptable because all of the other queries/DML
were taking up too much runtime en masse.
While lowest conceivable runtime is certainly a goal, it alone does not address
important things like scalability.
My $.02,
Rich
Rich Jesse System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
-----Original Message-----
Sent: Tuesday, September 07, 2004 11:49 AM
Subject: RE: Should you still tune queries by LIOs?
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
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
