Re: BCHR Tuning

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 <ORACLE-L_at_fatcity.com> 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: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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).