This is from grandpa's memory:
The wait interface (v$system_event, v$session_event, v$session_wait) were
introduced in 7.0.12. So if my memory works correctly at this early hour, that
was 1992. In 1995, I wrote the Oracle7 wait events and enqueue paper, after Jeff
Needham explained a couple of
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:
Yes,
I forgot to mention Gaja's book, and there is a book out there Oracle DBA 101,
that has a complete section (2nd or 3rd) about tuning by wait interface/YAPP.
Anjo.
Greg Moore wrote:
2001 - a lot of books are published with wait
interface / YAPP methodology
Tuning 101 gets a lot
[EMAIL PROTECTED] wrote:
The paper is a condensed version of the book
Oracle Performance Tuning 101 published by
Osborne (ISBN 0-07-213145-4). This is an
EXCELLENT book and worth every penny that it
costs.
actually i think it's worth more than it costs, but that's just because
it made me look
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
Rather than a genus, how about a species ?
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Monday, April 22, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
it's opening statements is the classic formula:
response time = service time plus wait time.
My own mantra puts in rather less scientific terms:
If you have a performance problem,
One needs to keep in mind that Waits are the symptoms, and not a problem.
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
Well absolutely true, but then everything the database does is a symptom of
the fact that we throw workload at it ;-)
Deshpande, Kirti wrote:
One needs to keep in mind that Waits are the symptoms, and not a problem.
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 12:13 PM
Then it depends on the workload and its quality quantity ;=) because, the
database does what it is asked to do ;)
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
Well absolutely true, but then everything the database does is
It's on page 3, line 38. That includes the front page. Never figured out
why you waste a lot of words before getting to the point, Anjo?
Mogens
Jonathan Lewis wrote:
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
it's opening statements is
Indeed. When looking at R = S + W I truly get scared when I see stuff like
400 = 399 + 1. Doesn't leave much room for database work, does it?
Anjo Kolk wrote:
Well absolutely true, but then everything the database does is a symptom ofthe fact that we throw workload at it ;-)"Deshpande,
Is that the one where they just copied your whole YAPP paper in without mentioning
you at all? I seem to recall seing it at IOUG-A last year, but my memory
has always been and will always be bad.
Mogens
Anjo Kolk wrote:
Yes,I forgot to mention Gaja's book, and there is a book out there
Ah, good point about Jeff Needham who's now partner with James Morle (ScaleAbilities).
I hear rumors that Jeff might also be going to the Database Forum in Sydney.
We should have a historical gathering there where we wait in line while everybody
else get serviced.
Mogens
Anjo Kolk wrote:
Well Mogens,
I clearly remember the point you about 1500 word a day people and 5000 word
a day people at my kitchen table. Well I am typing now and my wife is on
the phone ;-)
Anjo.
Mogens Nørgaard wrote:
It's on page 3, line 38. That includes the front page. Never figured out
why you waste
James Morle's Scaling Oracle8i is my favourite book on Oracle performance,
and covers the wait interface excellently. Highly recommended.
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 6:48 AM
Yes,
I forgot to mention
Hello all,
Someone posted a link to a page describing what was going on at ioug-a.
This link spoke of a presentation (by Gaja?) that addressed tuning without
ever looking at a ratio.
Are these papers available to the public or only to attendees? I really
really wanted to go to this meeting
] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Sunday, April 21, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: ioug-a question
Hello all,
Someone posted a link to a page describing what was going on at ioug-a.
This link spoke of a presentation (by Gaja
Oracle Press
Gaja Vaidyanatha
ISBN 0-07-213145-4
HTH,
-Ron-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu,
Lisa
Sent: Sunday, April 21, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: ioug-a question
Hello all
The paper is a condensed version of the book
Oracle Performance Tuning 101 published by
Osborne (ISBN 0-07-213145-4). This is an
EXCELLENT book and worth every penny that it
costs.
Koivu, Lisa wrote:
Hello all,
Someone posted a link to a page describing what was going on at ioug-a.
This
0-07-213145-4
HTH,
-Ron-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu,
Lisa
Sent: Sunday, April 21, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: ioug-a question
Hello all,
Someone posted a link to a page describing
There seems to be a lot of interest in the tuning revolution here, so...
The basics revolve around the views v$system_event, v$session_event, and
v$session_wait, and v$event_name - and the 10046 event. Rather than try to
paraphrase/summarize/expound upon the details, here are some of the best
Nice post. The 'revolution' is indeed not that new, more
of an underground guerilla movement.
And it wasn't televised. :)
Jared
On Sunday 21 April 2002 10:33, Don Granaman wrote:
There seems to be a lot of interest in the tuning revolution here, so...
The basics revolve around the views
23 matches
Mail list logo