Re: CPU Costing

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 9 Sep 2003 19:54:43 +1000
Message-ID: <3f5da3d3$0$6524$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:1063080455.463722_at_yasure...
> Setting up a demo for my students for the Fall with the new DBMS_XPLAN
> built-in package and I am getting the message:
>
> "Note: cpu costing is off"
>
> Which would be fine if I could figure out how to turn it on or off or
> set it.
>
> A search of tahiti.oracle.com yields only two references to CPU Costing
> neither of which explains anything related other than a statement that
> it is user-defined ... user defined ... how?. And a check of
> v_$parameter indicates that it is not something modifyable in the
init.ora.
>
> Any help will be appreciated. Thanks.
>

exec dbms_stats.gather_system_statistics is your friend.

Regards
HJR Received on Tue Sep 09 2003 - 04:54:43 CDT