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 amateur latex video
  • hot sexy erotic video
  • free mature and son movies
  • facial explosion sex
  • exotic young teen non nude pictures
  • Lesbian sex videos shufuni
  • dirty ebony teen
  • all good boobs pictures
  • free mommy anal pics
  • rane revere shaved pussy
  • young blond nubile naked
  • d porn free video
  • lesbian ass dildoing
  • sexy babes having sex flash video
  • young henti sex porn
  • free teenages girls galleries porn
  • hd sex pics amateur
  • free cartoon monster sex movies
  • mature euro porn videos
  • hugh pussy holes
  • porn pictures of hentai pokemon
  • blondes anal sex
  • pussy giving birth pictures
  • tight anal virgins
  • Jenna jameson nude images
  • sex fat girl tube
  • casero juguete sexual anal
  • nn young teens photos
  • free amateur homemade lesbian porn videos
  • wife sex talk
  • zulay henao naked video
  • wife upskirt pussy pictures
  • Asian ass movie
  • anal vids free
  • young teens lads
  • married couple with girl threesome
  • mouth fuck free videos
  • Little teen anal
  • Pictures of tight pussies
  • fun black big butt
  • teens xxx cumdrenched
  • all mature video
  • old man girls big tits
  • adult movie naked housewives
  • best pornstars xxx fuck
  • very young teen sex pics
  • Hot girls lesbians
  • suck boob movie
  • indian girls fucking father videos
  • girls only teen porn softcore
  • free girls fucking guya ass porn
  • u yube free asian teen porn
  • petite blonde fucked
  • Big breast grope
  • sexy girls meta cafe
  • big cock in teen blonde
  • girl terror videos
  • shemale fuck hot girl
  • erotic art gallery ancient
  • mature amsterdam anal girls
  • oral food fetish video
  • free hardcore pics young party
  • minni sexy girls
  • amature wife sharing videos
  • big ken suck my dick bitch
  • tiny little nude girl pics
  • pussy closeup pictures
  • asian porn hub free
  • teen lesbian sex mpegs
  • hot chick having orgasm free video
  • suck and fuck video trailers
  • granny blowjob picture
  • women orgasm audio video
  • phat apple bottom pussy
  • girls like most after sex
  • Collage girl fuck
  • Short sex movie
  • naked espn video
  • granny fuck black cock
  • virtual sex devon onilne video
  • ass sex fuck photo free
  • wife squirms away black
  • tricks to make a girl orgasm
  • sarah underwood new fake boobs pictures
  • My personal big breasted masturbation maid
  • asian shower massage video
  • pussy filled cum
  • great amateur sex
  • philippine amateur sex
  • nutella hardcore video
  • ashley juggs sex fuck
  • naked sexy excited girls
  • sexy young teens with big tits
  • milf interracial xxx
  • ebony black babe
  • free hardcore anal fuck videos
  • my friends gangbanged my japanese wife
  • bare boobs videos
  • close ups o fmature pretty pussy
  • Hot nude dancing
  • Hot girls showing there pussy
  • amateur black couple
  • drunk sex nude videos
  • shona sexy wife
  • Sanskrit porn sexy indian girls
  • bodyrocktv butt videos
  • dancing young girls in underwear
  • Hottest girl nude
  • Porn in ass
  • fee hardcore sex videos young old
  • pictures of girls in volleyball shorts
  • sexy lingerie porn movie
  • free cartoon pussy videos
  • granma tits handjob video
  • japanese ass party
  • Anna nicole smith sex movie
  • teen girls with big tits
  • Red hair pussy pics
  • black babes geting fucked
  • asian krazy clothing pics
  • free lesbian porn galleries
  • fun sex with wife
  • cigarette in ass smoking video
  • asian lesbians eating pussy upclose
  • teen asian nudes
  • youngteen sex video
  • Light skin girls getting fucked
  • youngest teen models nude
  • see girls in bikinis have sex
  • pics of adult girls swallow
  • pussy during sex
  • small or petite sock aid
  • petite women milfs
  • wife swap sex uk
  • lesbian mature taboo
  • hot black girls getting fucked
  • white guys black girl tube
  • very young girls giving footjobs
  • xxx dp wife vid
  • oral sex deep throat long videos
  • very young teen fuck vids
  • black ebony hardcore videos
  • three teen girl riverton wyoming
  • movie tom cruise simulation reality
  • wife pregnant another man erotic story
  • girl bending over fuck
  • russian teen sex videios
  • huge tits in public flashing video
  • greatest puffy nipples gallerys
  • interracial xxx dvds
  • black oral cum
  • girls fuck while sleeping video
  • webcam slut teens
  • uk mature pics
  • hot girl sex fuck made love
  • Hot boobs in bikini
  • sperm on sisters pussy
  • bleached blonde and black haristyles
  • christmas bikini girls
  • erotic adventure pics
  • teen babysitter fuck vids
  • black girls squarting pussie
  • free hardcore pornography movies
  • sexy pussy nude gallery
  • free ebony nude women movies
  • hot blonde strip video
  • retro interracial pussy
  • teens young movies free
  • bbw anal sex pics
  • naked pic of college girls
  • a free sexx big girls
  • white ass black dick trooent
  • sexy well hung naked men galleries
  • video inside a pussy
  • all girl threesome pics
  • Hot girls moan
  • beautiful mature black women
  • African girls sex video
  • shemale movies gallery
  • legal amateur adult videos
  • naked girl getting boob job
  • black man ass shots
  • black fuck asian in backseat
  • pictures of all sex positions
  • My first sex teacher hot sex
  • naught horny young teens orgy videos
  • free ethnic indian sex
  • hardcore patries porn
  • petite saline st barths caribbean
  • naked lesbian russians
  • black pretty bitch
  • undressed japanese beauties sex movies
  • angle tattoo on girls pussy
  • spring break teens naked vid
  • vintage black female porn
  • free nude pics black
  • dana plato pics porn
  • dick sucking porn pictures
  • Male teen nude
  • Threesome amateur video
  • free asian vidao porn
  • granny tits and pussy
  • Angel locsin sex video
  • thunder video japan
  • live russian girl sex cam
  • farm porn free vids
  • Video sex homme
  • sexy dress up party girls
  • coco pussy xxx
  • picture young teen
  • boys suck huge dicks
  • topless girls in pink short skirts
  • Lesbian anal licking video
  • asian girl massage and blowjob video
  • black girl white guys gangbang
  • shy teen pussy stretch cum
  • fat black girl pictures
  • chick rubs pussy on cam
  • forced to suck a black
  • wife interracial galleria
  • free fat girls sex
  • anal naruto girl
  • cp porn sex pictures
  • pussy breasts org
  • naked and porn
  • rocker sex video
  • Youngest nude teen
  • reality kings free movies
  • mom sex nude pics
  • naked shower video of miley syrus
  • irish red pussy
  • please dont cum im my pussy
  • sexy asian slave
  • black mamma butts
  • natural hairy redhead anal video
  • sexiest free galleries of college chicks
  • russian teen erotic art
  • sarak palin swingers pics
  • mature women pussy flash
  • group sex syracuse ny
  • babes ass ive sex free now
  • youngest boys naked
  • amateur webcam nude videos
  • rocker girls porn
  • kiwis having hardcore sex
  • employee brutalized boss fuck video
  • married women threesome sex
  • amateur pussy girl
  • little girls porn mischka
  • naked little young black girls vids
  • black guy white girl forbien romance
  • anal sex piedra
  • slutload wife hubby amateur
  • xxx young eastern women
  • amateur indian wifes
  • erotic loving wife stories
  • old man sex with young girl
  • Namitha hot nude
  • Bella teen burg
  • sexy girls in leg warmers
  • cyber babes galleries
  • lesbian porn grid
  • sexy swedish naked girls webcams
  • free video hardcore busty blonde babes
  • Breast actives pictures
  • sri lanka girls ass caning
  • hot sexy nude girls having fun
  • how to lick out my girlfriend
  • burnette porn video
  • xxx shemale toon english titles
  • roxy jezel real wife stories video
  • viet porn videos
  • Love sex videos
  • sss cards xxx teens
  • free hot teen vids
  • my husband only wants oral sex
  • sex shower teen
  • sexy biker girls posters
  • mega fox amanda seyfried lesbian sex
  • Salma hayek sex scenes
  • beyonces pussy lips
  • porn college fuck party
  • Yung teens downloands video
  • pictures of asian teen tits
  • downlead free sex movies
  • nithyananda sex scandal videos mins
  • videos of elderly couples having sex
  • hot asian sex chubby movies
  • india summer amateur videos
  • free homegrown ebony videos
  • teen girls having anal sex
  • inticing women into having oral sex
  • asian pussy squirters
  • black throat traci lords
  • pics of men eating womens pussy
  • Lesbians eating out pussy
  • tickle feather god clit pussy hahahaha
  • Big boob pic gallery
  • naked mylie cyrus picture
  • girls clubbing videos
  • teen lesbian nubile
  • Black cock in ass
  • nude bikini galleries
  • brothersister erotic cametoe videos
  • young girl underwear model
  • free teen blowjob pov movies
  • Dawson miller nude video
  • video preview sex
  • hot teen pussy anal
  • old man cumming on young girl
  • big bootie chinese pussy
  • Lesbian pic porn
  • girl and porno site
  • hardcore pussy vibrators
  • celeb pussy scene
  • wide spread pussy and ass
  • strip tease video erotic
  • Flat chested skinny teens nude
  • asian massage parlor explicit video
  • what is pussy juice
  • yound girl sex videos
  • look down young girls blouse
  • teens looking to fuck other teens
  • asian girlsporn videos
  • young old love sex pix
  • blackberry teen pussy
  • german sex bukkake stockings mature
  • movie stars sex videos
  • older chicks and teens
  • big fat girls with little tits
  • free hardcore sex vids online
  • asian americans sex role expectations
  • erotic hard sex fantasy
  • sex by pool at party
  • erotic hd sex
  • main stream movie with actual sex
  • Indian mother son sex
  • blonde housewives fucking in kitchen
  • my boss could see her pussy
  • young college fuck
  • glamour model black cock
  • black girl with louise stubbs
  • asian large dildo video
  • lesbian erotica sex
  • emma sayle sex party
  • naked halifax girls
  • hardcore kinky rough galleries
  • black alcohol bottle with picture
  • sex in delhi free pictures
  • young asain chicks nude
  • trini girls sex pics
  • cumshot facial sexy asian
  • severe pussy whipping videos
  • How to do anal masturbation
  • natural tits free video
  • party club girls you tube
  • sexy cheerleaders boobs
  • Sweet naked ass
  • piratesxxx porn download
  • free sexy girls masturbating videos
  • nyomi banxxx mean amazon bitch
  • streaming ebony porn
  • Russian nude videos
  • free video older women sex
  • hot cnn chicks in public video
  • classy katia mature videos
  • Lucy pinder sex movie
  • ebony college girl fucked
  • vintage mature home movies
  • illegal girl dick licks
  • proper etiquette for teen girl
  • shower scenes in porn movies
  • coco bikini pictures
  • jessica mcclintock petite dresses
  • mature first time lesbians sex pictures
  • blonde teen tease
  • black actors sex scene meta cafe
  • girl in more boy fuck
  • blue black granite picture
  • mom sex mature free pics
  • naked girl with pictures
  • th century sex wife husband
  • petite night gowns
  • yout tube twink porn videos
  • nasty amateur teens
  • Bikini girls porn
  • erotic milla jovovich pics
  • very young iraqi pussy
  • scooby doo fuck idrawporn
  • milf cock sucking sex pictures
  • Models teen nude
  • teen girls tied up video
  • girls beauty pageants
  • matureworld yannis mature sex forum
  • Xxx sexi girl
  • good free porn video websites
  • xxx dildo pics of teens
  • special teens movies
  • Hot girls in beach
  • black teen sucks a white cock