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@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared.Still@xxxxxxxxxxx Sent: Thursday, August 05, 2004 3:22 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------