Antogini, On 5/2/07, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
Hi Ujang The latch free is taking less than 10% of the response time. So, if you have a problem is not the latch... The main problem I see is that you have no partition key in the WHERE clause. Therefore no partition pruning is used and PARTITION RANGE ALL is causing too much logical I/O for nothing.
I agree with this, do u mean that trans_id column isn't local index?
Few more comments... > I guess because of that index, so we could have problem with > latch free event, or any other clues? It would be interesting to know why... Which is the latch you are waiting for?
most of latch is buffer_cache_chain. regards ujang -- http://www.freelists.org/webpage/oracle-l