Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: CPU Costing Date: Tue, 09 Sep 2003 08:17:15 -0700 Organization: ATS Message-ID: <1063120615.59003@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1063080455.463722@yasure> <3f5da3d3$0$6524$afc38c87@news.optusnet.com.au> In-Reply-To: <3f5da3d3$0$6524$afc38c87@news.optusnet.com.au> Content-Type: multipart/alternative; boundary="------------050903090408020702050408" Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 117 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242696 --------------050903090408020702050408 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Howard J. Rogers wrote: >"Daniel Morgan" wrote in message >news:1063080455.463722@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@x.washington.edu (replace 'x' with a 'u' to reply) --------------050903090408020702050408 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Howard J. Rogers wrote:

"Daniel Morgan" <damorgan@exxesolutions.com> wrote in message
news:1063080455.463722@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@x.washington.edu
(replace 'x' with a 'u' to reply)

--------------050903090408020702050408--