Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CBC Latch contention in 10g

RE: CBC Latch contention in 10g

From: Smiley John - IL <SMILEYJ_at_tusc.com>
Date: Thu, 21 Oct 2004 13:26:52 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF168808709924B94@tuscil_ex1>


Perhaps fanfare was too strong a word. I was greatly encouraged by what I read about CBC latch sharing for reads in Cary's "Why You Should Focus on LIOs Instead of PIOs" and Richmond's "Oracle Wait Interface:..."

Regards,

John Smiley

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Thursday, October 21, 2004 11:38 AM To: oracle-l_at_freelists.org
Subject: Re: CBC Latch contention in 10g

I don't know if there is any published material on this - I think I got the important bit of it from Steve Adams' masterclass.

It's likely that the sharable cache latch used some of the time is better than never having it at all - and Oracle does keep finding new ways to (a) reduce the latch acquisition, and (b) switch to single latch reads anyway, so scalability does keep improving.

Where did you see a fanfare about sharable latches, I didn't spot it. I'd be interested to see how it was presented.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 21 2004 - 13:22:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US