Re: ioug-a question

There is always Steve Adams' "Oracle8i Internal Services - for Waits, Latches, Locks and Memory" from O'Reilly (undoubtably the all-time record holder for information density). It is best considered as "Foundations for Advanced Tuning" - as described on the cover. Chapter 2 is devoted to waits, but other sections also have wait-related information. I think the best advanced material is still in whitepapers at this point though.

Aside: In the migration to wait-based tuning, don't forget that even waits alone don't cover everything. Service time is the other significant component. I like Craig Shallahamer's anallogy - in the grocery store, one "waits" in line, then gets "serviced" by the checkout clerk. Even if the wait is moderate, overall response time (grocery store checkout line enqueue to checkout completed) may be poor because of a slow clerk!

Don Granaman
[OraSaurus - Honk if you remember UFI!]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, April 22, 2002 3:18 AM

> > 2001 - a lot of books are published with wait
> > interface / YAPP methodology
>
> Tuning 101 gets a lot of play here, and they devote a chapter to it.
Other
> than that, what books cover waits in a significant way? Thanks.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
> INET: sqlgreg_at_pacbell.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_cox.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).