Re: CBC latch contention on index root block

From: Sayan Malakshinov <>
Date: Sat, 19 Jan 2013 01:13:01 +0400
Message-ID: <>

Tanel, am I right that "scalar subquery caching" can help too?

On Sat, Jan 19, 2013 at 12:56 AM, Tanel Poder <> wrote:
> Try without the FILTER loop (if you know the (max) number of elements to
> check for, use multiple queries selecting only one value, concatenated
> with UNION ALL - this will make a difference for contention).

Best regards,
Sayan Malakshinov
Senior performance tuning engineer
Received on Fri Jan 18 2013 - 22:13:01 CET

Original text of this message