Re: CBC latch contention on index root block

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 19 Jan 2013 01:13:01 +0400
Message-ID: <CAOVevU4oHzMnVS3eZG+3==Qx5YtcFwtq9JYUhTmr=i7xt3qsnA_at_mail.gmail.com>

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

On Sat, Jan 19, 2013 at 12:56 AM, Tanel Poder <tanel_at_tanelpoder.com> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 18 2013 - 22:13:01 CET