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