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


  • free online ametar porn video
  • malaysian sex online video
  • pocket pussy for sale
  • online sex storys to read xxx
  • dinosaur babes movie for sale
  • video
  • hot free lesbian porn online
  • kate beckinsale tits in the movies
  • free farmgirl sex movie s
  • video
  • sex with costumes videos
  • video
  • free ebony porn sites online free
  • porn video online
  • instructional sex online videos
  • shemale on females videos for sale
  • girls halloween costume sexy
  • sex with cheap makeup girls
  • porn videos free online watching
  • video
  • ebel petite classic wave sale
  • female xxx diaper sex free online
  • sexy holic school girl costume
  • video
  • video
  • free online furry sex videos
  • school girl twins teen halloween costume
  • online reality porn videos
  • youmg teen girls vidoes
  • video
  • video
  • freee online deep throat videos
  • black and white costume party
  • buy amateur porn videos
  • free online videos ass fucking
  • video
  • free online porn videos of teens
  • video
  • teen girls online sex webcam
  • free wild online homemade sex movies
  • movies costume hardcore
  • video
  • mature movie rentals online
  • video
  • free sex videos clpis online
  • amateur video sex download online
  • cheap free pussy
  • free xxx fuck stories online
  • free online streaming of handjob videos
  • video
  • free online young girls videos
  • video
  • Sex online video
  • watch lesbians orgasm online
  • anal free online porn first time
  • kate beckinsale underworld evolution naked videos
  • video
  • buy big black dicks movie
  • real life sex videos free online
  • online free videos of sex
  • video
  • fuck buy sussex
  • free anal sex online videos
  • video
  • video
  • no cost full length porn video
  • imgsrc young pussy
  • free online sex video red heads
  • video
  • free porn videos online no download
  • kate beckinsale topless video
  • buy black cock shock video
  • Kate beckinsale naked pics
  • video
  • free online young girls videos
  • video
  • storyline porn movies streaming online
  • online erotic movies free for women
  • video
  • free full online sex vids
  • pussy cock sex video free online
  • cheap nude teen video
  • erotic online stories for girls
  • Sex and the city full movie online
  • rhinestone chokers bitch sexy wholesale
  • sexy couples holloween costumes
  • mad hatter costumes for teen girls
  • free online hardcore pussy licking videos
  • homemade sex video wife lomgest
  • couples seduce teens in costumes
  • video
  • where to buy shemale movies
  • online shemale asin videos
  • erotic videos buy shop
  • costa rica sex pics
  • ebony magazine dreamgirls photo
  • free online doctor checkup sex videos
  • video
  • free online black dicks midget
  • rated x couples porn online videos
  • free online streaming of handjob videos
  • free online anime shemale videos
  • Hindi sex movies online
  • video
  • petite cotton batik skirt sale
  • watch free blowjob videos online
  • little girl porn online videos
  • halloween costumes fuck party
  • Dress up sexy girls online
  • sex videos period costumes free
  • video online ass
  • watch online free teen sex movie
  • erotic porn free online for women
  • free full porn videos online
  • watch softcore movies online free
  • sex on megavideo online
  • video
  • cheap petite pants
  • free online pictures of erotic massages
  • bangla sex video free online
  • video
  • giant ass dildo video free online
  • video
  • online hardcore porn videos
  • video
  • fat girl porn for free online
  • dicks sporting goods black friday sales
  • free costume porn videos
  • little caprice foursome movies
  • la petite academy cost
  • online videos of sex
  • baileys fuck buy porn
  • buzz bake sale young teens
  • eating disorders and young black women
  • online blonde sex videos
  • desi porn videos online for free
  • kate beckinsale sex movies from underground
  • teen asian ass pee mgp
  • video
  • video
  • free online adult softcore romantic movies
  • watch homemade couples porn online
  • free online hindi sex movies full
  • black girl porn for free online
  • Indian sex movie watch online
  • bbw online porn videos
  • indian sex porn movies online
  • watch free ebony porn online
  • video
  • free online hairy pussy porn
  • eating disorders in teenage girls
  • video
  • free online lesbian porn xxx
  • video
  • indian sex movies online free
  • online blowjob vids
  • Kate beckinsale sex scene video
  • black sex girls for sale
  • video
  • video
  • online porn videos indian girls
  • teenage girls costumes
  • girls doning gilrs porn online
  • young amateurs pics online
  • free video online sex
  • video
  • video
  • asian sora aoi movies watch online
  • topless college girls in elf costumes
  • buy porn movies in bangkok
  • video
  • video
  • asian porn free online
  • hardcore sex free online
  • erotic young girls costumes
  • meet for free online sexy girls
  • video
  • read black erotic stories online
  • free online wild sex movies
  • sexy xxx teens online
  • chubby girls porn dvd cheap
  • free online photos mature sexy ladies
  • teen sex pics wearing costumes
  • video
  • video
  • video
  • video
  • buy teen pussy
  • free online ebony porn movies
  • video
  • video
  • video
  • video
  • costumed sex pictures
  • free online brazillian sex island videos
  • where to buy korean couples shirts
  • psychiatric disorder associated with anal sex
  • college girls sexfor tallahassee sale
  • anal sex movies for sale
  • video
  • video
  • amateur porn movies online
  • online hollywood erotic movies free
  • online hot teen movies
  • sexy girls in lingerie costumes galleries
  • video
  • erotic boundaries full length movie online
  • x vids costume sex
  • lesbian sex porn online
  • video
  • teen costume pics
  • video
  • online shemale lesbian porn videos
  • free online videos of girls stripping
  • streaming online free hentai porn video
  • sexy online videos of teen lesbians
  • texas mail order girl watching movies
  • teen costumes for girls
  • video
  • free soft core porn movies online
  • video
  • best ebony online movies
  • video
  • cool teenage girl clothes cheap
  • lindsay price naked pics
  • video
  • video
  • halloween costume hardcore porn
  • sexy school girl costume canada
  • sexy magical girl online
  • petite size costume
  • free online videos of girls stripping
  • sales girl shows tits
  • free hentai porn movies online
  • asian girls in costa rica
  • webcam girls online forum
  • sex with cheap makeup girls
  • real teen anal long online videos
  • californiion devils threesome watch online movies
  • asain pussy for sale
  • video
  • free online asian sex tube
  • video
  • free online japanese porn tube
  • downloadable asian porn for free online
  • online sex free videos
  • young buys naked
  • watch x rated asian movies online
  • free erotic drama movies online
  • Teen online video
  • watch free sex videos online
  • video
  • indian porn videos online
  • deep throat xxx online
  • watch full length erotic movies online
  • mature cheap sexy street walker pics
  • video
  • buy woods shemale schoolgirls torrent
  • video
  • teen ffm mgp
  • rhinestone chokers bitch sexy wholesale
  • india porn video watch online
  • amateur porn videos online
  • free online hardcore porn
  • video
  • online teen girls adult
  • online video contests for teens
  • latina pussy border bangers
  • island caprice studio asian videos
  • sexy wife fuck costume
  • video
  • naked online girls with big boobs
  • free farmgirl sex movie s
  • xxx porn trainimg bras
  • katie price pussy papparazi
  • hardcore online webcam sex
  • video
  • petite jean meats online
  • large object in pussy free online
  • asian mgps free xxx
  • free sexy girls online
  • blowjob sex stories online
  • video
  • video
  • womens petite clothing and discount
  • free online school teen sex videos
  • free online cheating wife swallows video
  • free online young sex videos
  • free gang bang porn online
  • video
  • video
  • pictures of german ethnic costumes
  • valley girl movie online
  • online shemale asin videos
  • freeonline porn movies
  • free online pics of oral sex
  • free online girl masturbating videos
  • buy cartoon porn videos
  • bikini airways movie online
  • video
  • indian asian dvd movies sale
  • online video girls fucking guys
  • free online mature grandpa sex stories
  • teens sexy angel costumes
  • porn online video tube slayer
  • husband buys wife a fuck present
  • video
  • free sex pics victorian costume
  • free wet pussy sex pics online
  • video
  • cheap petite black separates
  • young girls lookimg for older men
  • sexy sleeping beauty halloween costumes
  • video
  • video
  • free black porn movies online
  • asian school girl costume
  • free online tiny teens videos
  • girls having sex on camcorder
  • facial abuse free online videos
  • online mind control erotic sex story
  • Big tits video online
  • video
  • video
  • plug buying guide butt anal
  • video
  • school girl costume for teens
  • buy victor mature movies
  • best online porn video
  • best buy movie sex scenes
  • free online porn girls riding cock
  • hardcore porn online free
  • eating disorder teens guys verses girls
  • the other boleyn girl movie online
  • video
  • petite adult halloween costumes
  • free online black teen porn videos
  • eating disorder teens guys verses girls
  • video
  • petite cowardly lion costume cheap teen
  • free ebony girls xxxx movie online
  • flip video gb black forsale
  • teen ffm mgp
  • free homemade sex videos online
  • asian porn online free
  • valley girl movie online
  • buy sexy black dress
  • free porn pics and vids online
  • watch free online japanese cartoon porn
  • online porn room live webcam
  • having sex online video
  • ebony squirting videos online
  • video
  • asian mature women xxx cheap
  • free online blacks hardcore fucking videos
  • buy asian girl
  • video
  • watch free erotic movie online
  • young girl belly dance costumes
  • black and white asian border prints
  • video
  • free online camle toe sex videos
  • free sex and porn videos online
  • blonde milf reverse comgirl
  • online hardcore anime action movies
  • video
  • teen girl fuck buys
  • free online young teen videos
  • online cartoon sex videos
  • watch online japanese anime bible black
  • free blowjob movies online
  • lesbian sex free videos online
  • pictures of naked costa rica women
  • teen sexuality costs on society
  • video
  • teen online streams sex
  • video
  • online hindi sex movies
  • good porn video online
  • pussy pump for sale
  • anal teens free online
  • free online lesbian sex movies
  • petite sophistie online alog
  • free online naked wemon videos
  • black online video sex sharing
  • free online ebony porn videos
  • free online sex video films
  • funkyimg young girl
  • video
  • free ffm cumguzzling xxx
  • buying pussy in charlotte nc
  • watch online free porn videos
  • video
  • Sex movies to watch online
  • japanese girl singing new order
  • video
  • katie price hardcore sex
  • dvds to buy shemale fuck videos
  • video
  • video