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