| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Tunning (DRPP)
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, BINAY.KUMAR_at_ponl.com ><mailto: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 >>
-- 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: teci_at_the-testas.net 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: ListGuru_at_fatcity.com (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).Received on Sat Feb 02 2002 - 06:42:23 CST
 |
 |