Re: CPU Costing

Howard J. Rogers wrote:

>"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
>
>
>

Thanks to all that helped. Now if we could just get Oracle to document that someplace within a few light years of EXPLAIN PLAN and DBMS_XPLAN.

How about it Oracle lurkers? ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)