Re: high latch free

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Wed, 2 May 2007 09:38:07 +0700
Message-ID: <3edcb66e0705011938o34e4d669w11e5f14110e2dbb1@mail.gmail.com>

Antogini,

On 5/2/07, Christian Antognini <Christian.Antognini_at_trivadis.com> 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

Received on Tue May 01 2007 - 21:38:07 CDT