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 
  • asian on white
  • free brothers and sisters sex movies
  • young girl teen naked
  • blonde lesbian stars hardcore lesbian sex
  • european party
  • young girl natural tits
  • Scene girls xxx
  • hot girl hot tits
  • video streaming western classic retro
  • videos de amateur
  • Naked nepali girls
  • snowtrails bikini pics
  • asian nostril licking sex
  • hardcore teen school
  • story girls sex
  • teens pussy fucking oral sex scenes
  • teen girl cumshot
  • post girlfriend beach purple blurred topless
  • Girl fuck pics
  • free new sleeping sex movies
  • naked teen babby sitters
  • perfect pink teen pussy
  • teen does anal
  • black star cum
  • handjob teen photo gallery
  • naked sexy ladys
  • petite white sweaters
  • threesome ebony
  • girl pussy smell
  • sexy teen vaginas hot dominant
  • black studs sucking dick
  • matureworld yannis mature sex forum
  • new lindsay lohan sex pictures
  • anal sex portland
  • young teen pantyhose
  • sailor moon shemale videos
  • joke wife picture of boat
  • oral sex cum shots
  • young pussy up close videos
  • teen virgin fucked pics
  • totty teen girl poses
  • free gaint dildos movies
  • happy naked teens
  • cumshot tits pics
  • picture of pussy and dicks
  • hermaphrodites sex pics free
  • asian twink free video
  • hot sexy boobs sex pics
  • petite brunette masterbating
  • sex best friends girlfriend
  • sex stag party for women
  • pictures of beyonces butt
  • girlfriend suck dick
  • statistics on sexually active teens
  • Sharon stone sex scenes
  • skinny lesbian teens sex
  • teen sex young
  • kids bikini videos
  • erotic teen sex videos
  • teens scissoring video
  • Virginie ledoyen nude video
  • white girl cumshots
  • pregnacy with anal sex
  • Black ass master
  • free classic star video
  • str teen videom
  • stretch petite short pants
  • older women younger boys fuck
  • granny anal pics
  • Killing me softly movie sex
  • petite girls big toy
  • hot brunnet tits sexy
  • squeaky clean pussy
  • ebony girlfriend pics
  • Nude sex
  • free online crying fat movies
  • lesbian hentai rough sex
  • aphrodite orgasm videos
  • Nude picture of ash
  • girls you know going topless
  • tiger woos star girl friend
  • oral sex aiction
  • brazilian teen lesbian
  • real webcam sex full length
  • University hot girls
  • Japanes sex movie
  • Porn sex tits
  • rubbing tits video
  • Sexy iran girls
  • young girls nickers
  • hottest shemale pics
  • naked girls mountain hiking
  • handjob schoolgirl story
  • clasic erotic video collections
  • erotic story for girls
  • little girl naked pussy
  • free hardcore daily videos
  • Smoll girls sex
  • jennifer love hewitt hardcore movies
  • shemale on girl videos free
  • snapping pussy creampie
  • bbw asian tv
  • japan girl masterbation tube
  • free videos handjob
  • tight young teen movies
  • larry levine petite pants
  • Incest sex galleries
  • party naked pictures
  • girls to young for pics
  • first brunette asian anal
  • public flashing movies
  • busty curvey girl
  • naked pictures of cheerleaders
  • free suck my cock movies
  • babes blondes
  • passed out anal fuck
  • wife on wife sex video
  • japanese girls in sailor outfits
  • anal gaping
  • Nude indian grils
  • video young girl self fisting
  • tits boobs hardcore sex
  • free girls who squirt cum
  • domanate oral sex
  • erotic jailbait girl
  • free huge nude girl pics
  • girl homemade sex
  • homemde fuck videos
  • Russian teen whore
  • Angelina jlie sex scene
  • teen amature movies free
  • young petite hotties
  • free full sex videos megerotica
  • free caught having sex videos
  • wife swapping movie websites
  • sweet young pussy to lick
  • Natural big tits pics
  • fisting anal sex
  • young naked girl teens
  • thumbnails big black boobs
  • sucking fuck videos
  • mature women teaching young girls
  • adult couples nevada sex
  • videos of naked boys
  • lesbian twins have sex
  • blonde teen being fucked
  • cute jeans pussy
  • mother in law handjob videos
  • anna sex pictures marquette
  • tiny asian girl fuck video
  • stories of teenage girls spanked nude
  • berry halle naked video
  • orgasm sites xxx
  • Big boobs tight shirts
  • my wife seduced a young man
  • Lucy liu nude pics
  • bbw amateur sex
  • using fingers during oral sex
  • Big titts curvy asses
  • wife cummin vids
  • shemale tranny fist anal
  • nina young pictures
  • biggest butts in
  • japan av idl girls
  • cute teenage pussy
  • girls naked camera
  • naked sexy japanese girls
  • free ameteur couples
  • ghost sex with sleeping girl
  • free amateur emo girls
  • pussy n tits
  • free hot hardcore videos
  • naked simpson pussy
  • Naked topless girl
  • young models facial
  • free sophistied older lady sex pics
  • so so young girls sex tube
  • trapping cute girls into lesbian sex
  • young sexy swingers
  • drugs and sex videos
  • front seat oral sex
  • young ripe tits
  • Beautiful pussy videos
  • Chinese actress sex scene
  • asian girl gettting erotic massage video
  • Anal massage vids
  • large pussy small cock
  • young girl nude tits
  • Nude boobs of actress
  • Chubby teen dancing
  • Too much wanking
  • threesome vids
  • masuimi max sex videos
  • armpit girl suck
  • sexy bikini jessica simpson
  • pale redhead anal video
  • black bigg butt queens
  • young girls homemade sex video
  • wife bra pictures
  • fuck your girlfriend for cash
  • free young teen moves
  • teen anal sex fucking
  • muscular black man fucks wife
  • interracial sex small white girls
  • Pussy sewing video
  • beautiful girls young hq pic
  • school galleries
  • Megan fox nude movie
  • free comics video
  • download asian video
  • free videos of forced enemas
  • girls getting cum in ass
  • young lesbo girls kissing
  • illegal young girls photos
  • young girl erotica pussy pictures
  • Paris hilton big tits
  • young girl gives head
  • teen trampoline creampie sex
  • College girls having sex
  • girl tied up erotic tickle
  • young sex pics india
  • young girls doing deep throat
  • free teen fucks video
  • roleplay anal beads vids
  • petite blonde escorts
  • mature adult intertainment videos
  • hot white teen girl
  • perfect oral sex slutload
  • Photo big breast
  • free pussy sleeping videos
  • Indian teens gallery
  • sleeping black teens
  • sexe video amateur telecharger
  • lesbian bondage sex in shower
  • bloody free videos
  • lesbian gang attacks straight girls
  • kelly molnar sex pictures
  • thin skinny petite nude
  • black and white teenage girls
  • women bound and gagged videos
  • is clifton davis wife black
  • xxx creampie teens
  • naked girls doing cocaine
  • asian girl fuckking video