Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10053 trace

Re: 10053 trace

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Tue, 27 May 2003 21:14:47 -0800
Message-ID: <F001.005A3D2C.20030527211447@fatcity.com>


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

-- 
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).
Received on Wed May 28 2003 - 00:14:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US