Jonathan, Since you've mentioned it, how about summarizing those mistakes for the rest of us?
This goes for you too, Mogens. :) A few things didn't sound right to me, but I don't often spend time doing actual tuning of the database. My tuning usually involves fixing or working around development errrors. When I have to actually tune the database, I just pick the worst offenders from the wait stats, and then figure out how to fix them by reading everyone else's research and/or experimenting. Which is a long winded way of saying this stuff doesn't last long in my internal LIFO buffer. :) Jared On Saturday 11 January 2003 01:16, Jonathan Lewis wrote: > A brilliant solution. > > I knew that the "real" Steve Adams couldn't > have edited it when I say the line starting: > > <quote> > Latches are low-level queuing mechanisms > <end quote> > > The man who wrote THE book about latches in > Oracle couldn't possibly have made the mistake > of thinking that latching was a queueing mechanism. > In fact, there is a bit in Steve's chapter on latches > which says quite specifically: > > "....latches do not support request queueing.... > latch requests are not necessarily serviced in > order." > > > > Having said that, I thought the article was far better > than usual. There was still plenty of scope for > criticism, but it seemed to convey more useful > information than usual, even though presentation > and ordering were somewhat garbled in places, and > there were several small errors and misunderstandings. > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Coming soon a new one-day tutorial: > Cost Based Optimisation > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > ____England______January 21/23 > ____USA_(CA, TX)_August > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > > -----Original Message----- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: 11 January 2003 06:51 > > > Undskyld! > But you assumed that the Steve Adams mentioned at the bottom of that > article is the one you know ;)) > > They should have mentioned Steve's Web site. They did not miss tusc > and ioug URLs. Ummm..... wonder why not ;) ;) > > I say poor Copy Editing on part of the publishers. > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
