Tuning will never totally go away since some duveleopers will still code like this(as well as them dumb gui tools):
select a.deptid, b.last_name from dept a, emp b where a.dept_id = '22; Oh look a cartesian join, how lovely. Duhveloper: DBA why does my query take so long? DBA: let's talk about tuning. joe Danisment Gazi Unal (Unal Bilisim) wrote: > 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, [EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> 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 > > -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
