RE: CBC Latch contention in 10g
- From: Smiley John - IL <SMILEYJ@xxxxxxxx>
- To: "'jonathan@xxxxxxxxxxxxxxxxxx'" <jonathan@xxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 21 Oct 2004 13:26:52 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jonathan Lewis
Sent: Thursday, October 21, 2004 11:38 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
