Re: Oracle Tunning (DRPP)

Hello Mogens,
My name is called danisHment by many foreigners. But, I'm not from Denmark. The names mentioned in your email and some others have done revolutionary things in Oracle tuning. They are unforgettable names. Although there are some measurement errors in YAPP, it  is a revolution for Oracle tuning. A senior director in Oracle development emailed me that Oracle would implement some new features mentioned in DRPP. I don't know the the level of tree-depth of Oracle's implementation.  I'm offering all possible levels (6 levels) in DRPP.
As a result, performance problem analysis will not be a problem (about 100% accuarcy) with next versions of Oracle. Perhaps, tuning analysis will disappear. It may seem not so nice for DBAs. But this is the reality. I think, prediction of performance will be pre-dominately talked in the future. This is more human based.
regards...
Mogens Nørgaard wrote:
Hello Danisment (if only you had the extra h in there, it would be DanishMent which would be really cool :) ) - Sounds interesting. The YAPP formula (R = S + W) is of course not totally correct (wait time for the run queue, etc.) but seems to be a fair approximation. And it sure beats the checklist tuning approach (let's try this, then this, than that and finally this). May I suggest that you let Anjo, Cary, Bjorn and Steve review your paper, too?
Best regards,
Mogens
Danisment Gazi Unal (Unal Bilisim) wrote: Hello
Mogens and others,
Yes,
You are right. But the current time based performance techniques still include errors. Prior to 80's(when I was a child), yes, ratio based measurements were the method. Then, wait-event based profiling appeared. In fact, this was an adaptation of Response Time Performance Profiling to Oracle. Unfortunately, there are significant errors in current response time based performance profilings. I've been working on a new performance profiling for 1 year. and now, I've almost completed my paper. The name is Deductive Response-time Performance Profiling (DRPP). It'll be available on my site after my seminar in Turkey. You can see the contents at http://www.unal-bilisim.com/resources/drpp_seminar.html .
Also,
Thanks to Jonathan Lewis, K Gopalakrishnan, and Tim Gorman for reviewing this paper for 1 year.
regards...
 

Mogens Nørgaard wrote:
Commit; :-)
In my opinion, you shouldn't spend your money on buying the Niemich book. It's full of errors (increase the buffer cache hit ratio, for instance) and the wrong approach (no time-based measurement method, just checklist after checklist).
Buy 101 by Gaja. Then buy Tom Kyte's One-On-One book for general fantastic advise on anything. Then go to oraperf.com (Anjo), hotsos.com (Millsap), ixora.com.au (Steve Adams) and Jonathan Lewis' website (can never remember the adresse). Or go to MiracleAS.dk and find all these links, including the book links.
Mogens
Miracle A/S
Denmark
Farnsworth, Dave wrote:

Binay,

I totally agree with this recommendation from Jared for a tuning book. Read the first three chapters, stop and re-read them.  And if you play your cards right you can even get a question answered by an author on this list.  Cool, eh.

Dave

-----Original Message-----
Sent: Tuesday, January 29, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L

Start with 'Oracle Performance Tuning 101',  available at an amazon.com near you.

Jared

On Tuesday 29 January 2002 09:10, BINAY.KUMAR_at_ponl.com wrote:

Hi Everyone

     Can anyone suggest me some very good book on Oracle Tunning.

Please only

mention those books  which you think is really worth purchasing

Binay Kumar
Oracle Cerified DBA

London

The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through our network.

--
Danisment Gazi Unal
http://www.unal-bilisim.com


 



--
Danisment Gazi Unal
http://www.unal-bilisim.com