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


  • anorexic teen pussy sex
  • worlds biggest boobs on asian girls
  • saggy hanging tits video
  • Nice ass shot
  • russian young bbs video
  • uncircumsized dick
  • asian ts tranny movies
  • tube big black ass fucked
  • lesbians xxx sex
  • Hollywood boobs sex
  • erotic softcore videos
  • country wife analysis
  • fat ebony lesbian tube
  • free pics naked amateur teens
  • Best teen jokes
  • young amateur videos
  • free two big cocks in pussy
  • movies with light bondage
  • top with young sex
  • free nude lesbian college
  • spanking teen girl punish linik
  • young black teen videos
  • adult movies flashing
  • summer walker video girl
  • girls got rythym video
  • black woman shoveling hay picture
  • photo sexe black gratuite
  • free videos piss teen petite
  • raver girls sex
  • sexy bitch mature
  • daughter sex dress video
  • hot girls screaming fuck
  • sexy girls posing naked blowing
  • Teens double anal
  • bikini on a plane movie
  • best fake pussy free
  • boobs good sex
  • pictures cum in pussy
  • ann angel pussy pics
  • sexy nude young teen girls
  • Black pussy gallery
  • Wet thong pussy
  • teen girls group sex
  • teens for cash facial
  • ovguide sex videos
  • blonde soroity girl in thong
  • japanese teen cute
  • hot teens fuck cum videos
  • brazilian sex party
  • girl flashing in walmart
  • wife fuck black man
  • mega mature sex
  • fuck fuck xxx
  • Brazil ass licking
  • auburn over pussy thumbs
  • pics of fantasy girl
  • very young girl touching vagina
  • mature woman fucks young lad
  • teen oral sex pix
  • sex webcam strip pussy tits
  • how too long to pump pussy
  • jabba tit slave leia fuck pussy
  • xxx moms family sex films
  • shaved pussy s
  • videos of blowjob
  • thongs on young girls
  • east bay edued sbm girl sexy
  • young girls butfuck galleries
  • Soundtrack from sex and the city movie
  • my dick her ass
  • most viewed amateur pics
  • Lesbian mallu sex
  • sexy secretary babes
  • girl in a bandeau top bikini
  • Hot girls pole dancing
  • Malavika nude video
  • perfect girl nipples
  • sexy horny stocking strip tits
  • teen girl caught
  • nicole anal sex celebrity
  • dominat wife sex stories
  • girls lesbian blonde
  • Hot girls fuk
  • Teens caught masturbating
  • lesbian slut having sex
  • ptm pt movies petite teens sexxx
  • lds views oral sex
  • throat young powered by vbulletin
  • latino petite girls
  • dominican free movie
  • hot group sex stories
  • Teen cock videos
  • sexy teen girl holding cup
  • melissa camel style fuck video
  • Pussy nigga video
  • britny spears sex pics
  • Gina lisa sex videos
  • Keira knightley sex video
  • lezben teen sex
  • holly hernandez playboy sexy wife
  • videos of black lesbians
  • beach ball pussy
  • interracial wife dvd sale
  • hot orgasm
  • Elisa cuthbert nude pics
  • Rachel bilson sex scene
  • infection broken skin sex anal
  • kvartal lesbi janka
  • art nude young girls
  • naughty teen free video
  • Sexy japanees girls
  • ebony black public girl strip
  • black mail my mom friends
  • tranny shemale free video
  • cfnm free handjob pics
  • sexy nude teen girls next door
  • girl one guy
  • video nun
  • girls with facial cumshot
  • free long shemale movie
  • couples dildo play video
  • erotic adult medical videos
  • tiny japanese virgins
  • large closeup clit vids
  • plunger in pussy
  • Ass loving lesbians
  • livia kovacs in a movie
  • japanese asian whores galleries
  • stinky anal sex
  • Hot sex telugu
  • xxx best ass
  • bonding pics
  • christine young vids
  • johns brady wife pictures
  • xxx farm fuck video
  • pics of naked sportsmen
  • wife doesnt like oral sex
  • free black lesbian sex movies
  • teen twinks rimming pics
  • soljua girl video
  • greek sex video
  • free reality party sex vids
  • young teens with hairy arms pics
  • heshe fuck party
  • Interracial white sluts
  • miley cirus topless vanity fair pics
  • sum sex movies free
  • xxx star photographs
  • teens sexy video
  • pussy tarts photos
  • Big tits tight pussies
  • girls bravo hentai pics
  • Really big breast
  • what teens do with sex
  • girls swimwear bikini
  • Nude photos of lindsey lohan
  • black jada fire free sex
  • sexy hot girls in pittsburgh
  • amateur sex dvds
  • amateur wife sex toys
  • Sexy ladies breast
  • blonde girls amateurs
  • own videos sex
  • Real big boob
  • naked girls with tatts
  • tits extra pics
  • pics milf homemade ass
  • virgin sex movie
  • yougest teens fuck
  • pissing group sex
  • russian teen his boyfriends facial
  • homemade celeb fuck videos
  • Hot blonde big tits
  • videos sex teen
  • black chicks fucktube
  • hardsex video
  • Rhona mitra nip tuck sex scene
  • guys dick going into girls ass
  • rosanna davidson topless beach
  • latino finest ass free pic galleries
  • young ethnic schoolgirl gallery
  • homemade first threesome videos
  • my interracial gallery
  • high quality sex online videos
  • Hot blonde girls getting fucked
  • big boobs dick sucker
  • asian girl prisoners
  • sexy crazy teens
  • pound sex videos
  • free cherokee d ass videos
  • girls having sex audio free
  • japan nipples free pics
  • teen blackberry
  • videos sex in libary
  • drunk wife party fuck video
  • hot wife video free
  • teen full videos shaving videos
  • sexy naked latino women
  • free drunk girls videos
  • sexy girl playing with tight pussy
  • house wives hien sex tube vids
  • petiet asian nude teen movies
  • hq erotic movie
  • Teen titans xxx super powers
  • girl getting it anal
  • joanna cassidy topless in movies
  • perfect boobs picture
  • teeny bopper blowjob
  • Interracial amateur video
  • singapore sex swingers
  • free nude amateur big breast videos
  • thai anal small young
  • free ebony wet pussy pics
  • lesnian pussy licling
  • Rate my asian pussy
  • hairy nude girl galleries
  • sex in the city zurich movies
  • gotta suck dick
  • white guys who like black pussy
  • xxx video gratis mature
  • big booty ebony shemales videos
  • sexy asian nudist
  • deep throat with linda video
  • teens girls get gang banged
  • naked drunk coffman girl
  • Hypno sex video
  • mature young lesbian mpegs
  • very young manga girls
  • sex forum video
  • topless indian babes videos
  • fuck videos for itouch
  • gap petite jeans for woman
  • natrual naked drunk teens
  • chubby pussy fat women
  • wives having sex with husbands
  • ls girls pussy
  • Two girls get fucked
  • Dirty talk sex movies
  • big black tits asses
  • korean girl pictures october tint
  • Kelly brook nude sex
  • buy sexy black dress
  • babes pictures for ever
  • girls gone wild best breasts videos
  • pics of giant black dicks
  • Naked swimming video
  • drunk dorm naked pics
  • classic videos for sale
  • korean girl anal sex pics
  • naked girls web sites
  • free butt licking lesbians
  • free shaved latina pussy pictures
  • grant lili sandoval pussy
  • big boobs lezbo sex
  • pussy for free movies
  • free sex movies girls gangbanged
  • sex babes pool fantasy adobe flash
  • small girl gets facial
  • amie furnari lesbian
  • Black stud lesbian
  • free blowjob movies celebs
  • big boobs that are sexy
  • haitian pussy fuck
  • widow sex galleries
  • senior sweet pussy
  • mature movie galleries
  • thailand pussy sports
  • anal black teens
  • tight pussy girl
  • young old group sex
  • free pics galleries
  • girls diaper
  • pictures of naked boobs
  • Window girl sex
  • shooll girls
  • girl wants suck audio
  • free full length orgasm videos
  • max the black
  • minka xxx videos
  • free videos of couples eating pussy
  • sexy asian cum swallower babes
  • amateur naked home movies
  • bikini pics of madonna grimes
  • teens girls masturbating
  • hugh hefners wife and family pictures
  • teen lesbian land video
  • free no member ship movies
  • sexy teen girls get fucked
  • looking at butt joke ad
  • naked lesbians sleeping
  • white bitch loves black guys cum
  • power ranger sex pics
  • nude house wife pics