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


  • realy hot realy young topless babes
  • bible lessons for teenage girls
  • young blonde masterbating in public bathroom
  • hardcore modle for in australia
  • xxx adult free hardcore fucking
  • teen chirstain movies
  • picture egories
  • husband slave wife mistress pics
  • girl flashing big boobs
  • xhamster big pussy lips mature
  • petite latina mandingo
  • Adrianne bailon nude pictures
  • young japan idol movies
  • young mothers pussy
  • schizophrenia wife missing branagh movie
  • pictures exposed breasts
  • shemale sex movies galleries
  • Pamela anderson nude images
  • old guy teen girl sex
  • movies of sexy black teen feet
  • amateur teeny facialized
  • pregnant black chicks fucking
  • Brooke shields nude movie
  • ava vincent anal sex
  • Watch best sex scenes
  • sexy young girls thumbs
  • Ass licking photos
  • naked videos of francine prieto
  • Minka tit fuck
  • young teenagers flashing boobs tube
  • spreading amateur gallery
  • pics naked milfs
  • can a pussy get strep throat
  • young girls suck big dicks
  • kinky lesbian sex
  • mature young group sex
  • India sex gril
  • girls naked facial
  • Indian hot sex scandal
  • forced painful anal video
  • partylite girls candle
  • two young to fuck
  • old asian man fuck teen
  • small waist with big tits movies
  • watching couple fuck
  • womens dresses petite plus size pattern
  • wife swapping sex iubes
  • newleywed and sex video
  • slavegirl wife humiliation
  • hien tits pussy
  • chicks pics babe
  • fake david henrie naked pictures
  • i wanna taste my ass video
  • barbie party ethnic
  • sweet young pussy video
  • amateur wife cumming on my dick
  • hot lesbians eat pussy redtube
  • hot teen naked pictures
  • black that ass up
  • free swingers homemade videos
  • teen nudist naked nude art young
  • free movie women fuck men
  • nina hartley vintage interracial tubes
  • wife breast feeding pictures
  • family guy free cartoon movies
  • pics of youngest pregneant girl
  • Nude emo girl pics
  • girls first black
  • colorado interracial sex
  • free sex pics and vids
  • Angelina jolie fake nude pics
  • hand rail in pussy
  • xxx young teens
  • movie girl with giant thumb
  • xxx young trannys
  • naked girls of warcraft
  • beautiful girl titty fuck movie
  • you girl cumming
  • Prego sex
  • Naked muscle girl
  • free old men sucking nipples movies
  • Indian best sex scene
  • huge black blonde group
  • India boobs sex
  • naked girls of facebook
  • white girl pussy fucking
  • next door niki pussy
  • Tits lesbian pics
  • annabella angel pussy
  • best japan xxx
  • you black on white
  • voyeur beach sex videos
  • asian categories
  • pussy videos for
  • Kathy griffin naked pics
  • kimono girls hardcore dvd
  • girls bikini japan
  • insane amateur sex acts
  • teen having sex video
  • black on asian sex
  • indan wife sex desi
  • free hot young sex videos
  • older wife weing night fuck
  • black girls eating black girls pussy
  • petite flatchested girls
  • kiss ass lesbian babes
  • ass spread galleries
  • Sex scenes tara reid
  • group sex parties
  • Mariah carey sex photo
  • pregnant star pics
  • Hot girl black
  • anal disney
  • sexy young girls on cma
  • looking up little girls dress pictures
  • tied naked public sexy
  • mature mom home video
  • Nude actresses videos
  • Christian anal sex
  • married hairy wife orgasm creampie
  • Lesbians lick feet
  • bdsm teen hardcore
  • free anal young
  • young thai girl fuck movies
  • free pics of young nude celebrities
  • naked flat chested teen girls
  • asian personals sex
  • amateur mature german classic wife boss
  • bbw teen young fat
  • free online videos of insest
  • video femme mature fist fucking
  • beach pictures teen girls
  • blackwomen take it in ass
  • nude ebony teen pussy
  • sexy girl strip dance
  • pretty little naked girls
  • thai erotic massage videos
  • interracial sex and cuckoldry
  • tits dicks free
  • teen girl bibkini model pics
  • naked pictures of your wife
  • sex and sex teens
  • nancy erminia pictures naked nude
  • meghan heffern naked pics
  • Indian live cam sex
  • Sex in the city girls nude
  • hrine tate bouncing boobs video
  • anal sex causes prolapse
  • japanese xxx teen
  • shemale femdom anal spanking
  • Mutual oral sex
  • white sexy tits
  • naked pics of eva mendez
  • girl pics thongs feet
  • painful pussy fisting
  • little black girl lost
  • free erotic spanking videos
  • free asian women movies
  • streaming webcam
  • tits size shape gallery
  • naughty sex kits young
  • sniff my dirty girl ass
  • Girl drinks glass of cum
  • hot blonde has sex with stuent
  • pictures of star justine joli
  • rescue me sex scene videos
  • Nude island video
  • black phat ass girls
  • Hot girl dancing naked
  • naked videos of pretty girls
  • frist anal free
  • wifeswapping spanking novel club anal
  • Girl on girl naked
  • youth and beauty models pictureview
  • black dick gangbang
  • video girfriend naked
  • Lady death nude
  • pregnant pussy during pregnancy
  • free white gangbang vids
  • high definition facial cumshot videos
  • sexy babes girls wifes
  • video nude teen girl
  • black chicks cum
  • free sex pics and movie
  • fuck my wife blindfolde spread eagle
  • retro big ass boobs gallery free
  • watching wife fuck
  • very young k pics
  • Lesbian sex tits
  • public girls flashing
  • college girls and pics
  • teen girl sex viedio
  • pussy eating lessons
  • teen boys sex stories
  • young boy with bogs sex
  • japanese blowjob in cars
  • teen strips webcam
  • Hot and sexy emo girls
  • syracuse young sex
  • longer flash sex videos
  • asian school girl cartoon
  • dy little girl virgin
  • video of rescue me sex scene
  • Older hairy pussies
  • teens first fuck movie
  • gossip girl blonde actress sings
  • upost sex videos
  • sex video asian
  • pauly shore naked pictures
  • Mallu reshma nude sex
  • black girls fucks big black cocks
  • asian teen trannie
  • free russian oral cumshots
  • sexy midwest girl
  • hardcore three way fuck movie
  • free chubby nude girls movies
  • teen interracial videos free
  • orgasim young girls tube
  • free amateur flashplayer
  • amaxing blonde you
  • girls gone wild picss
  • transsexual group sex
  • topless vegas shows videos
  • black cum in wife tube
  • girls first time eating pussy
  • amateur sex orgasm video
  • dancers girls movies
  • brothers that suck dick
  • hard lesbian sex pictures
  • Home made indian sex video
  • crazy granny pussy
  • very young lesbian port
  • asian sex vedio
  • girl gallrey
  • dailymotion blonde college girl sexy
  • different ways lesbians have sex
  • naked stickam girld
  • busty teen rachel video
  • oral amber blowjob movies
  • Perverse sex videos
  • group sex kitchen
  • asian war
  • petite gagging cumshot
  • white guys gang bang black guy
  • large wife sex party videos
  • slender ebony hooker fuck vids
  • teen double vag triple vag sex
  • Fucking a passed out girl
  • best blowjob galleries
  • Huge bbw breasts
  • transsexual melanie videos shemale yum
  • ass worship free vids
  • crochet pattern petite irish rose
  • xxx serials cracked passwords
  • Hot oily sex
  • best ebony gloryhole streaming
  • crystal ray throat gaggers videos
  • perfect sexy ass
  • mature big tits fuck milf sex
  • young mscular girls
  • mature long vids
  • amateur wife deep throat
  • sexy girl jumping
  • calender girls helen mirren nipples
  • girl kneeling down to suck cock
  • dasani teen hitchicker videos
  • shemale anal veggie
  • brazilian pussy videos
  • ms black nude beauty
  • karen martin girl next door pictures
  • sexy lesbian pussy sex
  • big black butts hanging out
  • homemade video wife loud orgasm
  • latex blowjob movies
  • redhead mature galleries
  • snowtrails bikini pics
  • pussy pumped camel toe
  • inez teen model free pics
  • my black fuck
  • petite juene fille
  • amateur anal post
  • streaming sex masturbate girls
  • ass wife galleries
  • amputee sex pics
  • black rat snake pictures
  • wife swap home movies
  • bushy black girls
  • free video hardcore busty babe
  • tiny little virgin teen girl
  • teen naked myspace
  • black fuck milf wiesbaden mainz georgina
  • pussy pumps in my area
  • glamour babies girls glamour
  • xxx asian panties
  • Next door nikki naked videos
  • petite rolo chain
  • black breeding rack videos
  • pussy big tits viedos beach