Re: high latch free

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Wed, 2 May 2007 09:38:07 +0700


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.


Other related posts: