RE: system stats and LIO's

  • From: "David" <thump@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Aug 2004 07:17:05 -0700

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
-----------------------------------------------------------------

Other related posts: