cpu costing is off (consider enabling it)
oratestSep 14 2010 — edited Sep 14 2010Hi,
I am using Oracle 10.2.0.3.
Whenever I generate explain plan for any query, the very last line of explain plan is as below.
cpu costing is off (consider enabling it)_
It seems that optimizer didn't considerd CPU stats while generating plan for this.
How to enable CPU statistics here?
The parameter optimizer_mode value is "CHOOSE", and stats are being gathered at an interval of one week.
When I use CPU_COSTING hint in the SQL, then this line went away, and the query plan also started giving CPU % in PLAN output. But how can I make this a default behaviour of optimizer ( Any parameter etc to be set in oracle 10g for this)?
Thanks in advance.
Best Regards,
oratest