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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).