Re: Doubt related to ROWID
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 24 Jul 2013 17:37:08 -0400
Message-ID: <CAMVw97KSa_JEoqt7E8a9Hj2N+CqUP2Qrpjaj8qDSKrZ+bHSJ8g_at_mail.gmail.com>
One latch to be precise... the lowest number of latches possible ;-)
Date: Wed, 24 Jul 2013 17:37:08 -0400
Message-ID: <CAMVw97KSa_JEoqt7E8a9Hj2N+CqUP2Qrpjaj8qDSKrZ+bHSJ8g_at_mail.gmail.com>
One latch to be precise... the lowest number of latches possible ;-)
On Wed, Jul 24, 2013 at 11:04 AM, Jonathan Lewis < jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Well,
>
> You could avoid the LIO by using the result cache, but there are far fewer
> latches on the result cache, so not doing the LIO might cause more
> contention and therefore be more resource-intensive than doing the LIO ;)
>
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com/all-postings
>
> Author: Oracle Core (Apress 2011)
> http://www.apress.com/9781430239543
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 24 2013 - 23:37:08 CEST