RE: optimizer_index_cost_adj and optimizer_index_caching

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 05 Mar 2004 13:41:34 -0700
Message-Id: <6.0.3.0.2.20040305133820.02bfae38@pop.centrexcc.com>

Yes, you gather a separate set of stats for each significantly distinct workload and swap them in for that workload. The key word is significantly. Don't try to micromanage statistics. You are dealing with statistics, don't try to interpret more accuracy into them as there is.

At 10:23 AM 3/5/2004, you wrote:
>So you define the timeframe for gathering the stats. And in a mixed case
>workload, say OLTP during the day, big batch processing during the night, do
>you gather two sets of stats with an appropriate timeframe, and swap them
>out, just as described in chapter 3 of the 9i tuning guide? Do you find
>yourself needing to manually tweak the system stats? And I've seen systems
>where there is a predictable change in workload during the day, simply based
>on how people do their work, so in a case like that, maybe even swap out
>system stats during the day (assuming you have a good handle on how the
>system is used)?
>
>Regards,
>
>Larry G. Elkins
>elkinsl_at_flash.net
>214.954.1781

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

---

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 Sat Mar 06 2004 - 00:43:09 CST