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@(protected):
> 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@(protected)
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
-----------------------------------------------------------------