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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Confuzzled on OPTIMiZER_INDEX_COST_ADJ

Re: Confuzzled on OPTIMiZER_INDEX_COST_ADJ

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 18 Sep 2003 02:19:41 -0800
Message-ID: <F001.005D05E8.20030918021941@fatcity.com>


> To get the 10053 trace, you will need to reparse the query - you might
have
> to flush the shared pool or perform other shared sql invalidations (such
as

I normally just modify the query to have comment /* test1 */ or /* test2 */ etc. in it. That way it's easy to search from possibly long 10053 trace for specific instances of your query.

As Wolfgang stated, if you got only the QUERY string and query text in your trace then you're using either RBO, or your query isn't hard parsed which generates the full trace. If your statistics seem to be correct and optimizer mode is other than RULE and you still don't get the trace, try some hint such is first_rows, in your query to force CBO use. (of course this first_rows hint might change your execution plan itself, but is useful to test whether you get full 10053 trace at all).

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 18 2003 - 05:19:41 CDT

Original text of this message

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