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


  • sex pussy young free
  • forced to suck chicks ass video
  • fist black girls
  • teen cock lick
  • Teen arabia
  • free teen cyber sex
  • japanese amateur nudes
  • pregnsnt young girls
  • freckles blowjob video
  • petite girl strip
  • Porn sex in car
  • teen threesome fuckng orgy
  • young ones fuck good
  • free amateur movies sex
  • anal sex big cocks
  • free videos kaze
  • Google big boobs
  • frere kate hudson topless pics
  • shenae grimes sex naked pictures
  • huge clit large pussy ass worship
  • free dh movies
  • stripes bill murray naked pics
  • asian search sites
  • girls young pharaoh
  • vintage lesbian ass fingering
  • Interracial marriage rates
  • Hottest teen movies
  • nude female bodybuilders interracial sex
  • hardcore shemale anal action
  • trannies doing chicks vids
  • when girl fuck first time
  • tiedup abd handjob videos
  • shannon tweed pussy pics
  • exploited black teens angel eyes
  • teen suck mgp
  • Teen in bikini video
  • lined up ass anal
  • drunk blonde has sex
  • valery ortiz big ass pics
  • sexy babes in stockings
  • free amateur home made sex movies
  • hottest amateur anul videos
  • young woman mature body japanese
  • sexy nude women in hardcore sex
  • homemade hardcore gallery
  • Boy sucking boobs
  • black buafly ft fabolous bad girl
  • teens fuck best friends mom
  • homemade teen blowjob slutload
  • Free teen titans hentia videos
  • xxx hardcore free video
  • sweet naked black girls
  • teen pussy high resolution free
  • pussy being fucked
  • boy fuck by another guy video
  • sister pregnant brothers dick pussy
  • how do girls pee pics
  • braock girl
  • free video of asian girl
  • free hardcore black videos
  • amateur nude free galleries
  • young amateur pussy pics
  • lesbianas no sex
  • anal indian vids
  • movie et home imdb
  • girls in black
  • big pussy tshirt
  • volunteering to speak to young girls
  • black dicks white tits
  • fuck babysitter teen
  • sari fuck video
  • Lesbian scenes in movie
  • amateur bondage video gallery
  • boob fuck vids
  • free young cute teens
  • xxx fuck tv
  • candid down bikini pics
  • japanese restaurant served by naked waitress
  • Ass shake girl
  • free xxx pics solo girls
  • movie nell book sex
  • jewish girl giving a blowjob
  • teenage girl work out
  • black for ipod
  • teenage girl masturbating video
  • mature ebony sex pictures
  • hardcore japan
  • shemail on girl free video
  • sex videos sucking online
  • for older couples
  • forced teen sex black male stories
  • free hentai dick girls
  • stacy dash naked pics
  • cowgirl erotic bittorrent torrent
  • brazilian girl galleries
  • asian guy white girl
  • blondes fuck huge dicks
  • worlds best girl tits
  • nudist teen girls pool
  • blonde petite girl riding
  • back guy fucks white teen movie
  • free young tight teens
  • lesbians big butts
  • italian amateur
  • big pics venessa hudgens naked
  • girl with sex ray
  • lesbian teen tribbing videos
  • gratuit dilatation anal
  • sex party zurich
  • best voyeur amateur bra pics
  • russian hardcore video
  • big white blond pussy
  • street blowjob videos
  • jennifer ellison boobs video
  • free ffm strapon video
  • black latin guys girl
  • fuck his wife strong free
  • hot music video girls
  • Big breast bikinis
  • free concert flashing galleries
  • sexy butt pussy
  • teen fuck hairy video
  • free amateur couple sex vidoes
  • big ass ebony vids
  • pictures of naked exgirlfriends
  • homemade videos adult upload wife
  • girls boarding school alice movies
  • lesbian anal housewife
  • very young teenage girl forced russian
  • free mature massage videos
  • Nepali couple sex
  • drunk girls at pool party
  • blackmen white wife tube
  • blonde milf hd movies
  • young anime girls sex
  • knot stuck in girls pussy
  • hamster big pussy videos
  • clit fingering home videos
  • lexxxi lockhart facial
  • black women sex movies
  • sexy skinny black chicks
  • Bald pussy pics
  • teen naturist beauty pageants video
  • white pussy in ghana
  • free teen home videod
  • girls of babilicious naked
  • free video amateur feet
  • sexy ladies fuck tube
  • amateur girl thumbs tits
  • free widest anal gape gallery
  • Sexy tsunade boobs
  • videos boricua amateur
  • young and old fucking large dick
  • strips naked at party
  • black amature mature tubes
  • ebony teen lick
  • vintage video topless
  • amateur anal tube free
  • whois teh sexiest girl
  • black shemale sex cum orgy
  • agressive hardcore lesbian
  • Puerto rican girls xxx
  • mild guy on girl
  • tiny girls huge tits
  • free vids of celebs having sex
  • girls with perfect asses
  • free xxx blonde
  • slut mature lesbian
  • hot bitches eating pussy
  • cute bangladesi teen sex movie
  • amateur boy self pics
  • free videos of asian hardcore bondage
  • free pictures video
  • teen girl dressup
  • sexy teen gallery
  • hot group black sex
  • Italian sexy ass
  • secret teen pussy
  • homemade pussy abuse
  • aqua lesbian sex
  • tube interracial three black loads
  • first sex young
  • Young sexy girls video
  • pictures of pioneer girls
  • Hot lesbians sex video
  • shaved dick blowjobs
  • close up pussy in the crack
  • Tiny asian teen
  • girls cock facial
  • teens nasty sexy sex
  • Frequency of sex married couples
  • Girl kiss girl and sex
  • nice anal sex
  • sexy naked korean girls
  • hot very young
  • adult videos for married couples
  • Realistic vagina toy
  • Sex with punjabi girls
  • nude beautiful ass video
  • asian girl with big tits
  • tan line fuck movies
  • free hot pussy videos
  • Lesbians eating pussy photos
  • old man masturbation free videos
  • party girl getting fucked by
  • wifes st interracial sex
  • Sex iranian girls
  • stories black sex
  • girl fucked by lesbian
  • airwalk karma skate girls black uk
  • man fucks young teeen movies
  • forced pics
  • try teen anal gallery archive
  • interracial weekend sexual affair
  • interracial anal ass
  • flexible sex girls video
  • free handjob prostate milking movies
  • Thai girls
  • teen give old man blowjob
  • free online bleeding movies
  • free hairy pussy tube sites
  • flashing women amateur movies
  • paris hilton wet pussy
  • nudism teen galleries
  • nsfw teen fuck
  • hairy pussy orgasm masturbating
  • black wax for facial hair removal
  • anal virgins streaming video
  • slutload mature black pussy
  • girls photobucket naked picures
  • phat ass booty sex
  • tiny pussy
  • home orgasm vids
  • xxx female orgasm torrent
  • white wife black cock strap on
  • lesbian sex torture
  • dick in ass free amateur
  • cousin butt sex
  • Black teen ass fucked
  • free girls xxx
  • teens for girls
  • Perfect vagina pictures
  • mans bald head in pussy
  • Alyson hannigan sex pics
  • free mature swinger video
  • anal sex stories and pics
  • oral demonstration topics
  • sensational bikini girls gallery
  • hard anal fucking videos
  • Showing big breast
  • photos of wifes pierced pussy
  • teen girls first anal with mom
  • forbien movies amateur fuck
  • house wife forced sex
  • naked pregency pictures
  • ree i videos
  • housewife home sex video
  • amature and teen gallery atk
  • hot girl fuck vid
  • sexy abs and tits
  • big dick ass attack
  • tiny teen xxx
  • sexy star wars chicks
  • genuine lesbian orgasm
  • asian tranny vids
  • home made girl galleries
  • teen group sex
  • blackberry hardcore
  • hardcore pain torture forced sex free
  • xxxfuck by hot wife
  • hard busty tits xvideo
  • meet school girls in japan
  • Futurama sex pics
  • pictures ice la fox
  • free plump girl pics
  • Teen anal pics
  • colombian girls erotic
  • busty blonde teen throatfuck
  • scan sexually mature cautious aroused
  • spread pink closeup movies
  • streaming teen bikini free
  • wife fucks my friend video
  • cute young pussy photos
  • biggest dick ever
  • wife dates black
  • average sex life for married couples
  • free sexy vids matures
  • cock sex hungry wives vids galleries
  • free share my wife galleries
  • lesbians fist fuck
  • babes wanting dick
  • adult sex home videos
  • cross dressing movies
  • watchbeauty nude pussy