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
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
