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 ment
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 wast
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:
T
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 Orac
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, Kirti
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
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
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
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
it
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, eithe
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:
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,
[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
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
> 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
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 ev
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 vi
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
Would u mail it to me tooo , please ...
Also , if there is a possibility to get this (and others) papers somewhere
on the web...
THANKS A LOT !!!
-Original Message-
Sent: Sun, April 21, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
Ron,
Can u Also Mail me that Document if i
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.
Ron,
Can u Also Mail me that Document if it feasible for u.
Thanks.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn... forget... and learn again.
===
Lisa,
(Copy of response sent to your direct e-mail since list servers don't do
well with large attachments).
I will attach the white paper you are looking for. You should know that
this is a quick overview of the content of Gaja's book.
Here is my advise:
1) Join IOUG - There are tons of benef
22 matches
Mail list logo