Frits Hoogland came up with a very interesting project — Pgstatspack.

What can be better than a Statspack-like tool an Oracle DBA in the PostgreSQL world? Heh… right — only PostgreSQL Wait Interface. ;-) Oh well, Pgstatspack is a good start. Well done Frits!

Find more about  , , ,

Well, the guess-days might be just about over for SQL Server DBA’s. People who revolutionized Oracle performance tuning several years ago, are now working at SQL Server revolution.

Look what Anjo Kolk had to say about at the interview during Miracle SQL Server Open World 2008:

And here is Cary Millsap from the same event:
Continue reading ‘SQL Server Performance Diagnostic — Still Guessing?’

Find more about  , , , ,

ASH Masters is the new web-site about Oracle Active Session History and everything around it. There, you can leave your comments and questions about ASH and ASHMON, the tool designed after Performance page of Oracle 10g Enterprise Manager. Kyle Hailey is the one who designed this performance screen in Oracle 10g Enterprise Manager and ASH data is what’s used behind the scene. Thanks to Kyle and others, we now have ASH Masters.

But not only Kyle created ASHMON. He has provided the ASH Simulation package for those of us who are still running Oracle 9i or have no license on Diagnostic Pack for Oracle 10g. The dream has come true!

For those of you who prefer good old SQL prompt and feel more comfortable using “hard core” queries, there are some ready to use queries. This is also the right place to share your ideas how to use ASH and contribute your queries for the community. Because…

What goes round comes round. Ideas build off ideas. No inventor is an island to themselves. We all build of existing ideas or are inspired by current ideas, but when there is discussion, sharing and community the ideas can grow faster, be more fun and become more powerful.

Join ASH Masters — share your experience and ideas.

Find more about  , ,

This is just a bit of administrative information.

I have changed BAAG Comrades page. I removed the member numbers. Two reasons — (1) I have introduced moderation of registration a while ago and I daily discard spam and need to adjust sequence and do some updates after that and (2) numbers are not important — important that you are on the list and support the party.

I have also deleted few members that seemed like dummy registrations and not replied on my emails. Those were registered before registrations approval was in place. Hope that wasn’t any of you. ;-)

If there are any suggestions for improvements — let me know. If you are not a member — here is how. If you forgot you password, here is password reminder. You can always login and adjust your profile.

Find more about  , ,

One of the main reasons why it’s difficult to troubleshoot problems in complex environments is lack of documentation. This post is long overdue because it was inspired a while ago by Dan Fink’s post (again). Be sure to read it first.

From time to time, I see situations when one person leaving the company leads to a disaster that puts in danger the whole existence of multimillion businesses. Why? Because there is nobody else who knows how system works and how all its moving parts are connected. How does that happen? No knowledge sharing.

The most universal method of knowledge transfer is documenting stuff and I would argue that, most of the times, one hour of documenting brings to a business more than two hours developing new functionality in PL/SQL.

Actually, there might not even exist such know-it-all-wizard. Complex systems are not created in a matter of days or even months. Often, extreme complexity is the result of years or even decades of evolution. All those workarounds, bug fixes, re-designs, pressing deadlines — those friends of entropy win time from documentation tasks.
Continue reading ‘Avoiding Guesswork in Complex Environments’

Find more about  , , ,

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?
Continue reading ‘Can a Performance Tuning Tool be Complete?’

Find more about  , ,

Working mainly with App Server these days, I’ve read a manual or two… I’ve even bought them (my Oracle7 manual set takes about an arm’s worth of bookshelf and almost cost a leg too).

This all changed in 1997 when I loaded the entire database documentation set onto my new toy at the time, a Toshiba Libretto PC (which was about the same size as a hefty novel). Since then I’ve never looked back. Yes, I do periodically print out chunks of manual for reading on the train (as there’s no point keeping them longer than a few months I use all that single-sided junk mail you get), but more often than not I read documentation online. This has the following advantages:

  • you can easily search for terms across several books,
  • you can have several pages/books open at once in different windows,
  • you’ve got the right version for the software you’re running,
  • you can copy and paste any command examples you want to try.

All obvious stuff - so with such easy access to the documentation, why is it you still see lame questions (on Oracle-L, OTN discussion forums, etc) asking how to do such and such? Surely it’s quicker just to look it up… and you don’t have to wait for some kind soul to reply.

The Oracle manuals (and Cisco for that matter) are very comprehensive - yes, there are lots of them but these are complex products. Of course reading the manuals doesn’t solve a problem in itself… just not reading them means you’re more likely make things worse!

Find more about  ,

One of the great problems with guesswork is that you can be led down some very blind alleys indeed. This commonly occurs when you guess what the problem is, rather than diagnose it, and then embark upon a solution. Every time you find yourself doing this think of Miriam.

BAAG in action

Find more about 

Join BAAG Now!

It took me the whole last night and few additional hours now to adapt Wordpress for the need of BAAG party registration. You can now join the BAAG Party and see the list of its members.

Thus, everything is now ready for the call to arms. Together we provide community with invaluable resources on how to fight the predilection for guessing, show how to unite in building stronghold of the BAAG Party.

This is just a beginning, and there are many interesting ideas being composed now. Everyone should be given opportunity to contribute, voice one’s concerns, stories and problems, given a chance to make a difference!

Find more about  ,

BAAG is born

Today is Saturday, 16th of June 2007 and is the birthday of… (drum-roll please…)BAAG - Battle Against Any Guess.

This idea was sitting in my head for a while and finally materialized here. “Enough is enough” trigger was this Oracle-L thread followed by couple emails from Tanel Poder and David Kurtz. While replying to Tanel describing this idea, I carried on and imperceptibly for myself started this site.

Interested? Find more details here.

Find more about 
  • nursing home fuck videos
  • donna lewis naked pictures
  • girls in bondage videos
  • i fucked my sisters hairy pussy
  • wife impregnation video
  • lesbian older porn
  • amateur girl sex
  • max hardcore pisses in girls arse
  • videos gratis de foxy angel shemale
  • mmf stories with wife
  • home passionate orgasm video
  • free pics of mature ladies
  • Masturbating sexy girls
  • Latina girls sex videos
  • hot blonde nude pics
  • minnie driver nude sex video
  • free hardcore granny videos
  • gallery boobs greatest
  • white moms with young black pics
  • russian young virgins
  • greek girl sex pics
  • tube porn fuck my wife free
  • Lesbian chinese movie
  • preachers wife porno pics
  • Teens sucking tits
  • black huge porno
  • amateur uk desi porn
  • Bikini girls sex
  • the newest movies anal
  • mean girls facing your beauty
  • girl is forced video
  • busty big tits teen vids
  • petite teen fucked by monster cock
  • free teenage italian sex videos
  • hardcore japanese xxx
  • ameesha patel oral sex
  • trinas naked pics
  • jacuzzi orgasm movies
  • big ass booty butt vids pics
  • sex with smooth girls story
  • naked dave video
  • japanese street tit fuck
  • interracial sex pictures
  • naked mallu girl
  • free lesbian old young orgasms movies
  • mile school for teen girls
  • sex home video upload
  • amateur teach me to fuck video
  • blonde lesbiens first time
  • Pretty paki girls
  • noelia sex movie
  • sexy wife teasing husband
  • nude petite young women
  • free hardcore porn free
  • young teens anal abuse
  • blonde teen real belly punch
  • amateur black cock thumbs
  • free couples sex cams
  • karola boobs video
  • beuatiful nude young girls
  • very young white girl sex
  • veronika zemanova anal pics
  • Jessika blonde teen nicetits
  • hot young blonde masturbating
  • girls who love black cock
  • pre puberty girls pics
  • hairy girls fingering
  • pregnant sexy girl
  • man sex with movie
  • streaming video amateur mature
  • bizarre sex pics gallery
  • free pics hard girl sex
  • stripping girls naked video
  • sexy brazilllian girls fucking
  • petite pale interracial videos
  • amatuer movie anal
  • local swingers blacksburg virginia
  • free home made pussy photo
  • video severe whipping girls whip boys
  • over sexy mature
  • older women cunts gallery pussy
  • bikini girl butt
  • clearance petite clothing
  • french mature lesbian
  • free hardcore pornstar sex movies
  • hot girl shows her tits
  • red hair legal porn movie dowloads
  • wife bred video
  • free interracial hardcore threesome videos
  • Girls fingering there ass
  • australian sex party
  • pictures black nissan gtr
  • oldies having sex pics
  • demetri long sex movies
  • Young indian nude
  • Sex photo shoots
  • amatuer wife sex
  • free black girl web cam
  • free old and the young movies
  • pornstar handjob pov with cumshot videos
  • movie spoiler fat girl
  • girls on group porn
  • free porn asien videos
  • lezbo sex big boobs
  • milf lesbian oral cum
  • free asians on black movies
  • teenage girl fucking man on couch
  • hardcore free porno
  • double stuff pussy
  • free teen fuck mpegs
  • tattoo pussy pics
  • amateur lesbian amateur finger squirting sex
  • so young asian tits
  • Teen modeling classes in philly
  • white dick black chicks gangbangs
  • beautiful breasts movies
  • asian upskirt hien videos
  • g bikini galleries
  • blck dicks white chicks
  • harvard oral sex president clinton
  • illegal black girl
  • fucking a girl porn video
  • exgirlfriend and wife pics
  • orson family fuck galleries
  • juciy sexy ass
  • anal arab free movies
  • porn video real college girls
  • free ebony xxx photo forum
  • bikini crotch bulge girls
  • young teens tps
  • Pics of kim kardashian ass
  • Big office boobs
  • Lesbains licking pussy
  • videos of women fully naked
  • Hot girls big dicks
  • naked redhead teen
  • mature lesbian rimming
  • debbie naked galleries
  • Russian teens gallery
  • penelope cruz naked videos
  • naked stewardess lesbian
  • group sex types
  • teen naked pics of themselves
  • uofl girls naked
  • homemade mature movies
  • naked spring break pics
  • asian teen dped
  • three way lesbian sex
  • shemale butt pictures
  • mature sex black on white
  • nude pics of lady gagas boobs
  • Video of sexing
  • review best teen interracial
  • anal fisting porn
  • asian hand job public vids
  • free porn pics and galleries
  • jesica simpsons sex movie
  • fuck my wifes sister hard
  • sleeping milfs sex movies
  • fucking and oral sex
  • erotic mmf wife stories
  • melina perez golden girl gallery
  • shemale video anal
  • girl friends sex pics
  • storm lake iowa sexy girls
  • black lesbian teachers
  • great sex for a lifetime videos
  • husband eats cum from pussy
  • Real lesbians sex
  • free teem girls videos
  • futurama naked with sex
  • brazilian knotted pussy
  • group sleep sex
  • sex swingers in ironside oregon
  • free pics mature gangbang
  • black teahcer sex
  • movie shark tiny teen
  • asian girls in lingerie
  • free pics of naked wife
  • free anal porn video galleries
  • Hot girls sport
  • massive dicks fucking big tits
  • incredible sexy nude girl
  • free hardccore porn videos
  • british amateur porn video
  • teen panty fuck videos
  • violent lesbian sex video
  • maternity clothes small petite
  • best selling records among teen girls
  • abusive sex video
  • miley cyrus having sex movie
  • page girl porn
  • lesbian porn online movie
  • mom fuck gallerys
  • indian lesbian porn movies
  • blacks with wife
  • rough anal teen porn
  • vagina pics wet young
  • Jeans teen ass
  • mature hariy fuck movies
  • free porn girl in diaper
  • Hot teen gang bang
  • japanese show girl pigs xxx
  • Pron sex fuck
  • sexy nonnude babes sex nude porn
  • amatura lesbian interracial
  • black girl nice blowjob
  • only blonde girls
  • young ass fucked for first time
  • teen british shemale
  • Big huge pussy lips
  • anal blonde galleries
  • amateur cumshot video free
  • hot babes fucking movies
  • free amature threesome nude videos
  • teens fuck cash
  • fuck crazed young black ladies
  • anal sex young women sphincter elasticity
  • Sex between boy and girl
  • girl fuck movie
  • Period sex videos
  • celebrity pussy slips pirate bay
  • free amateur kissing videos
  • free fat teen anal movies
  • Wet pussy vids
  • Beutifull sexy girls
  • hardcore young girls get fucked
  • shemale fucked by video
  • girls seduced porn
  • african guy and japanese girl
  • young naked male humiliation stories
  • petite old sexy
  • Nude indian beauties
  • girls masterbation pussy
  • erotic jungle cannibal pictures
  • indian schoolgirl fuck
  • old mature fuck vids
  • young girls daily milking handjob
  • toronto protest naked girl
  • black ebony cunt fingered
  • samba sexy babes
  • swingers seaford east sussex
  • adult erotic lesbian daughter
  • shemale blonde pics free
  • naked teen pixs
  • free amature young male adult porn
  • christmas girl porn
  • milf boobs videos
  • black lesbian muffdive
  • gfs teen asian
  • polish mature pussy massage
  • ethnic girls thumbs
  • passionate sex gallery
  • teen sex mania camelstyle
  • asian sex tv show
  • wild mature party
  • husband watches wife take black
  • horny mature wives gallery
  • blowjob vids plus
  • chesses with petite sirah
  • sex white girls
  • blonde teen gallery
  • pics of black mens penis
  • Massages sexy teen free gallery
  • nude free tube naked xxx titless
  • shemale videos babes
  • history of pussy
  • fat black teen women fucking
  • red pussy hai
  • teen pussy fucking videos
  • hardcore teen scewing
  • oral sex videos amatuer
  • young girls school events pics
  • naked lesbo xxx sex
  • alexis texas oil anal video
  • mother anal teen tube
  • cum inside pussy fuck video amateur
  • playboy tv foursome free videos online
  • girls sex bondage
  • best time to have anal sex
  • ex girl friend porn videos
  • videos young boys smooth chests
  • pussy on car
  • gun in lesbians pussy
  • free mature woman seduces boy vids
  • Breast touching sex
  • tight seaters sexy girls
  • anal cowgirl front
  • free yougn teen fuck vidoes
  • porn stars in virtual sex videos
  • wet pussy cumin
  • teen girl jerking off teen boy
  • Two girls fucking hard
  • babes stockings vids
  • sexy rabbit girls
  • boobs suck pussy
  • free porn of highschool girls
  • video s girls masturbating
  • mature latina bbw pics
  • young black american authors
  • bikini girl and