Re: 10053 trace

If it has only the query part then the sql was not parsed by the CBO but by the RBO. Make sure the tables in the query are analyzed, or force the CBO by putting a hint in, even a bogus one that doesn't affect the plan like asking for a non-existing index.

At 09:14 PM 5/27/2003 -0800, you wrote:
>hi
>
>thanks for the info.i could make it work for some 9i
>sqls but a particular sql is not generating trace.
>the 10053 trace file has only the query para but no
>other details. the query selects from a simple view
>built on a table. will this make a difference?
>here is the query
>select id from sai.ext_view
>where (sai.ext_view.ind=0)
>order by id;
>
>where sai is the schema name,ext_view is a view built
>on a table and ind is a column in the table
>
>to force it to parse everytime(test1 to testn..is this
>a good approach?), i used hints like this below
>select /*test1 */ id from sai.ext_view
>where (sai.ext_view.ind=0)
>order by id;
>
>and finally when i see the 8i trace, there is a line
>which says "bitmap access path rejected" under access
>path:index(index only).
>
>what does this mean?
>
>btw,the platform is aix 5l and oracle version is
>9.2.0.3
>
>thanks again for taking some time to look into this
>sai
>
>
>-- Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> > At 04:15 PM 5/27/2003 -0800, you wrote:
> > >hi gurus
> > >i am trying to generate 10053 trace in 9i and have
> > met
> > >with no success.
> > >
> > >i used both 'alter session set events' and
> > >'dbms_system.set_ev'.
> > >
> > >i used the above two to generate 10053 trace for
> > the
> > >same query in 8i w/o problems.
> > >
> > >has anything changed in 9i?
> > >can you please help me on this?
> >
> > There is no difference in creating the 10053 event
> > trace in 9i as compared
> > to 8i. The trace itself is a bit different in some
> > areas. What is the
> > problem you are having? No trace at all? Can you
> > greate an ordinary
> > sql_trace and find it in the udump directory? BTW
> > what platform?
> >
> > Wolfgang Breitling
> > Centrex Consulting Corporation
> > http://www.centrexcc.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Wolfgang Breitling
> > INET: breitliw_at_centrexcc.com
> >
> > 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).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Sai Selvaganesan
> INET: ssaisundar_at_sbcglobal.net
>
>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).

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

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).