From mln@miracleas.dk Sat, 02 Feb 2002 02:08:17 -0800 From: Mogens =?ISO-8859-1?Q?N=F8rgaard?= Date: Sat, 02 Feb 2002 02:08:17 -0800 Subject: Re: Oracle Tunning (DRPP) Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 playyour cards right you can even get a question answered by an author onthis list.  Cool, eh.Dave-----Original Message-----Sent: Tuesday, January 29, 2002 3:05 PMTo: Multiple recipients of list ORACLE-LStart with 'Oracle Performance Tuning 101',  available at anamazon.com near you.JaredOn Tuesday 29 January 2002 09:10, BINAY.KUMAR@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 purchasingBinay KumarOracle Cerified DBALondon-------------------------------------------------------------------The contents of this e-mail are confidential to the ordinary userof the e-mail address to which it was addressed and may also beprivileged. If you are not the addressee of this e-mail you shouldnot copy, forward, disclose or otherwise use it or any part of itin any form whatsoever. If you have received this e-mail in errorplease notify us by telephone or e-mail the sender by replying tothis message, and then delete this e-mail and other copies of itfrom your computer system. Thank you.We reserve the right to monitor all e-mail communications throughour network. -- Danisment Gazi Unal http://www.unal-bilisim.com