Earlier this week I’ve attended RMOUG Training Days 2008 and one of the sessions was of particular interest. Mogens initiated very heated discussion about performance tuning methods that are currently in use and how inappropriate they all are because they still leave some chance for guesswork. No doubts that performance optimization has involved significantly in the recent years but there is still place for a lot of improvements. Thanks Mogens — you are invaluable BAAG supporter!

Daniel Fink was one of the presenters during that session and has done an interesting follow up. You probably know that couple month ago Dan expressed controversial idea that Oracle “wait interface is nearly useless”. My interpretation is that while wait interface removed a great deal of guesswork from performance troubleshooting, there is still a lot of times when analysts tend to rely on guesswork or don’t have other ways to go forward except educational guessing.

Now back to Dan’s most recent post — How useful are diagnostic/optimization tools?. I can’t agree more about incompleteness of performance tuning tools but can they ever be complete?

If you think about our life you would probably agree that every situation is unique. I don’t remember what philosopher said that “it’s not possible to enter a river twice in the same place”. Indeed, the current never stops and the river is never the same. No difference with Oracle and IT in general — there are no two exactly the same problems. Two situations could be similar if some differences considered to be unimportant but how do you know which differences are important and which not?

Imagine that many years ago you had several cases of latch contention that was caused by excessive parsing. You create a tool that provides suggestion to look into reducing parsing every time you have latch contention. We know now — this is obviously wrong, but in your experience at that time — it’s been always excessive parsing causing library cache latch contention. Finally, another situation showed that latch contention can be caused by hot blocks — cache buffers chains latch. It becomes clear that there are some differences that were not accounted for (i.e. unknown or claimed unimportant). That’s OK. Right? We are going to improve our tool and distinguish latches. That will work until other situations come up when contention for the same latch has a new distinctive reasons. Another time, it would be platform specific issue and so on and so forth.

As soon as we encounter new situation and new important criteria — we can improve our tool but it can’t be perfect and absolutely complete. Should we give up? Of course, no. Striving for perfection is the only way we can keep up and keep pushing the limits. Thanks god there are such people as Dan and Moans that push the limits.

PS: It’s been a while here without new activity. I remind to everyone that if they have something to say here — please do (just let me know and I set up your account for posting). Thanks to Simon and Niall for their support.

Find more about  , ,

One Response to “Can a Performance Tuning Tool be Complete?”  

  1. 1 Doug Burns

    Nice post, Alex. I was going to comment here or on Dan’s blog, but it grew a bit long ;-)
    http://oracledoug.com/serendipity/index.php?/archives/1382-How-useful-are-diagnosticoptimization-tools-Another-View.html

Leave a Reply


  • android pc suite download windows 7
  • activar download mode samsung galaxy s
  • brand x music kill streak download
  • bloodhound gang shut up download
  • battlefield 2 download free chip
  • brand x music volume 10 download
  • 20th century theme download
  • asus m2a vm download drivers
  • cara download buku library.nu
  • carmen sandiego novo download portugues
  • anya your voice download girlshare
  • audiobook krzyA?acy download za darmo
  • a onda download uploaded
  • britannica free download full version
  • amazon seller desktop download windows 7
  • aircrack ng free download for ubuntu
  • ancuta anghel album download 2011
  • arsAz bela AYarkAlarA indir download
  • ar rahman guru songs download
  • autodesk sketchbook 2011 download
  • apostila assistente administrativo para download
  • akon yalli nassini mp3 download
  • allexinno feat. starchild joanna download
  • busz szimulA?tor full download
  • 50 cent p.i.m.p download zippy
  • amor real gocho mp3 download
  • business cards organizer download
  • cara download waptrick lewat komputer
  • canoscan lide download software
  • a outra face download uploaded
  • auckland kolaveri mp3 song download
  • cd naldo na veia download gratis
  • ali haider songs download purani jeans
  • blue & me update 5.6 download
  • applicazioni blackberry 8310 download
  • adobe reader v 9.4 download
  • apprentice usa season 6 download
  • automatically download google images
  • aerobic exercise download free video
  • apostila trt analista judiciA?rio download
  • bachpan movie songs download from songs.pk
  • albertus medium download font
  • caii of duty free download
  • aesop rock delicate cycle download
  • brave heart pc game download
  • christmas carols download sheet music
  • arabalar 2 download gezginler
  • blessings of a curse download
  • bitmesin gAkhan tA?rkmen free download
  • avatar tla soundtrack download
  • casper game ps1 download
  • canon mp830 software download free
  • alma redemptoris mater download mp3
  • canon mx340 driver download windows xp
  • adobe reader 11.4 download
  • asus p5g41c m lx audio driver download
  • celos de amor download
  • 4x19 the zarnecki incursion download
  • cheloo album 2011 download
  • chalti ka naam gaadi download
  • active gold card software download
  • cinta cenut cenut smash download
  • akon y wanna love you download
  • century expanded font download
  • 4shared download video klip
  • booker t theme song download link
  • chrysler voyager diagrams download manual
  • chester see everything download free
  • amrit brar songs download
  • aspire 5315 drivers download free
  • ceramah puasa mp3 download
  • 2 cellos sulic hauser download
  • beck quA onda guero download
  • bolt browser 2.52 java download
  • american pie reencontro download
  • automatically download tv shows linux
  • avenir lt 45 book download
  • boots & braces download