Re: should I analyze system statistics on ORACLE 10GR2?

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 4 Mar 2011 10:33:19 +0530
Message-ID: <AANLkTikm+VhUQ3M5f0v26jk6YQv_K_PuBYUQGnMN+F9R_at_mail.gmail.com>

if you using cost based optimizer then you should collect stats.. I think...over a period earlier stats can be purged thanks....subodh

On 17 February 2011 01:26, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> I saw a ORACLE document "Performance Tuning Guide for Siebel CRM
> Application on Oracle Part I - Cost-Based Optimization Guide" On this
> article it say "don't analyze system statistics":
>
> ==================================================
> System Optimizer Statistics
> In 9i, Oracle introduced cpu_costing, a mechanism that allows the CPU cost
> of an operation to be included as part of the overall estimate. This feature
> is enabled in 9i only if you collect system statistics. This feature in 10g
> is enabled by default. Oracle Database 10g gathers two types of system
> statistics - statistics captured without a workload (noworkload) and
> statistics captured with a workload. In addition to CPU cost, disk I/O and
> memory utilization are also captured, to ensure that CBO picks the plan with
> the lowest estimated cost relative to other plans.
> Many Oracle DBAs attempt to leverage system optimizer statistics for
> further tuning of Siebel CRM application. Such actions may cause
> unpredictable degradation in performance of certain Siebel CRM application
> views and queries, and are strongly discouraged. We recommend that DBAs
> refrain from collecting system optimizer statistics, or altering any Oracle
> default settings pertaining to systems statistics.
>
> ============================================================
>
> I also see another ORACLE document say you need "analyze system statistics"
> to avoid stange thing happen.
>
> Can Anyone tell me should I or Should NOT 'analyze system statistics"?
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 03 2011 - 23:03:19 CST