Re: high latch free

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


Other related posts: