Re: BCHR Tuning

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 <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: Jared Still
  INET: jkstill_at_cybcon.com

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).