cache buffer chains/where in code

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Thu, 19 Nov 2009 17:56:18 -0500
Message-ID: <52a152eb0911191456t5c1ceff8p490fc16faec49ae4_at_mail.gmail.com>



Hello All,

I am troubleshooting cache buffer chain latch issues in 11.1.0.7 running on SPARC CMT cpu. I have AWR report, and I've determined which query is responsible for the bulk of the waits.

For that 10 min AWR period, the bulk of the waits are happening in the following cache buffer chain code path:

"kcbgtcr: fast path"

As far as I remember, this code path only happens for indexes? If this is correct, then I know what index is causing this in my query. If not, I have some latch profiling to do.

If anyone hash a link or a reference for the other code paths for cache buffer chain latch that would be some invaluable information to have. For example for these:

kcbrls_2
kcbgtcr_9
kcbgcur: fast path (shr)
kcbrls: fast release
kcbgtcr: fast path (cr pin)
kcbgcur_2

Thanks in advance.

-- 
Christo Kutrovsky
Senior Consultant
Pythian.com
I blog at http://www.pythian.com/blogs/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 19 2009 - 16:56:18 CST

Original text of this message