RE: 10053 trace

To add to wolfgangs comments

select /*test1 */ id from sai.ext_view
where (sai.ext_view.ind=0)
order by id;

Doesn't haNiall ve a hint whereas

select /*+ test1 */ id from sai.ext_view where (sai.ext_view.ind=0)
order by id;

Does.

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Sai Selvaganesan
> Sent: 28 May 2003 06:15
> To: Multiple recipients of list ORACLE-L
> Subject: Re: 10053 trace
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.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).