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
DenmarkFarnsworth, 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, [EMAIL PROTECTED] wrote:Hi Everyone Can anyone suggest me some very good book on Oracle Tunning.Please onlymention 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
