Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CPU Costing

CPU Costing

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 08 Sep 2003 21:07:54 -0700
Message-ID: <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.

-- 
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)
Received on Mon Sep 08 2003 - 23:07:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US