Re: TIMED_STATISTICS

It's not so resource demanding. I have it turned on on all my databases.
It isn't the same thing as STATISTICS_LEVEL = ALL, which also collects 
the OS statistics and is fairly expensive. Speaking of STATISTICS_LEVEL,
I do find the value of "TYPICAL" quite livable and not at all too expensive,
the same as optimizer_dynamic_sampling at level 3.
If your WORKAREA_POLICY is AUTO, the decisions are much better.
On 04/02/2004 09:38:49 AM, Surendra.Tirumala@xxxxxx wrote:
> Thank you Mark!
> The documentation also added to my confusion as it says.."Normally, it
> should be false..."

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: