RE: system stats and LIO's

From: David <thump_at_cosmiccooler.org>
Date: Fri, 6 Aug 2004 07:17:05 -0700
Message-ID: <000301c47bc0$0ea3ce50$6401a8c0@winston>

Well I am working with statements identified from statspack as top sql = and
then trying to determine if enabling system stats is improving those = queries
or not. IT does'nt seem that cut and dry... How do we determine LIO's?
Exec time can change due to caching, cost is not reflective... - david

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jared.Still_at_radisys.com
Sent: Thursday, August 05, 2004 3:22 PM
To: oracle-l_at_freelists.org
Subject: Re: system stats and LIO's

> Hi,
> I am testing the impact of system stats.
> From reading the list here I know the best goal to follow is to reduce =

> LIO's, not exec time, exec path, cost, etc. So, how do I determine=20
> LIO's for a given statement with and without
stats.
> Thanks
> --
> ..

Though LIO's are important, you need to determine which statements are worthy of your tuning efforts.

A few things to consider:

response time=20
frequency of execution
how important the results are to the users

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Aug 06 2004 - 09:14:54 CDT