Re: Help me read my 10053 trace file

Shao: I think your program has become a victim of the new costing model for bitmap indexes which was introduced in 8.0.6. Basically the new costing model assumes the 80% of the rows are costed in the old model and 20% of the rows are costed as they are spread across ALL blocks. Let us assume

Help me read my 10053 trace file

I have a query in which the predictate is like this: WHERE ln.metro_id = i_metro_id AND l.metro_id = :b1 ANd eld.metro_id(+) = :b1 AND ln.status_desc = 'ACTIVE' AND ln.daset_id = ld.daset_id (+) AND