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 
  • chuyen cad sang word download
  • download js2e runtime environment 5.0
  • download te veo venir soledad
  • free download of bhooter bhabishyat movie
  • download lil wayne president carter
  • taz digregorio songs to download
  • temper trap axwell download
  • download grease megamix mp3
  • dku 5 driver free download
  • x3 albion prelude 2.0 download
  • pk song free download 2011
  • download stop watch for nokia
  • download gucci everything red cafe
  • picture resizer download windows xp
  • free download of autorun remover full version
  • hannah montana soundtrack download zip
  • xlive 64 bit download
  • download amd fusion media explorer
  • download music world cup 2014
  • download m r james
  • need for speed download windows 7 free
  • spice m 5262 themes free download
  • 1.8 survival island download
  • download maya free full version
  • download filme o acampamento do papai
  • microsoft experience pack download
  • canon gl2 download video to computer
  • download beethoven symphony 5
  • download autodesk for mac
  • windows xp 3 download free full version
  • asus turbov download 64 bit
  • chuck season 3 episode 8 download free
  • download sera someone like you
  • download wiz khalifa name on a cloud
  • os 6 download for 9700
  • download itunes visualizer windows 7
  • download alesso dirty south city of dreams
  • download aloo chaat songs mp3
  • download park shin hye without words mp3
  • download bogdan artistu si adrian minune
  • asdf movie 5 download german
  • impossible kanye west download mp3
  • download lyrics why this kolaveri di
  • how to download authorstream
  • download kites the movie free
  • nanghihinayang ang puso ko download
  • free download pesedit 2011 patch 4.0
  • download my google music
  • jika melly goeslaw download mp3
  • download lagu standing in the eyes of the world mp3
  • sfr vodafone mobile broadband download
  • dove si vedono i download di mozilla
  • download transporter 3 full movie hd
  • e 40 download album
  • download ung dung facebook tren dien thoai
  • sphax download for tekkit
  • download google latitude for bb
  • arrolladora banda limon download
  • townsmen 6 nokia 5800 download
  • download one piece 414 sub indo
  • download battlefield 1942 for free
  • download rumble fighter cheat engine
  • download update dungeon defenders
  • hitchcock i confess download
  • download ativador do realplayer
  • download ajax toolkit library
  • download watsap for samsung
  • download oki 790 driver
  • download tujhe bhula diya hai
  • download the minutes black keys
  • nba 2k13 demo xbox 360 download
  • download game ban may bay 3d
  • no ordinary family episode 1 download
  • horizon download for xbox
  • download conde de monte cristo
  • download steam.exe for cs 1.6
  • download de desbloqueio de telemoveis
  • download pavtube for mac free
  • download vmware tools solaris 11
  • download thermal and a quarter songs
  • maze we are one download
  • download fan control for pc
  • download sajni jal mp3 free
  • la corda d'oro secondo passo download free
  • hiren's boot cd download espaAol
  • download driver dell optiplex 760 xp
  • hp 3055 laserjet download
  • download cd ney e nando
  • download grease el musical de tu vida
  • download rpf admit card 2012 kolkata
  • pandora 2 metin2 p server download
  • download able2extract professional 7.0
  • tennis match video download
  • cobra starship new edition download
  • almanaque de tatuagem download
  • htc legend download applications
  • hp deskjet f2410 driver download windows xp
  • noorie bally sagoo song download
  • download sad romance thao nguyen xanh
  • download truyen vuong phong loi 2
  • download benvenuti al nord ita gratis
  • download pico crazy for you
  • download mustafa jaane rehmat pe lakho salam
  • download liAAes preliminares de direito miguel reale
  • download of assamese mp3
  • brother p touch download software
  • stigmata my way download
  • download mariah carey ft nicki minaj
  • no limits download full
  • download hd kolaveri di video
  • download contact us php
  • download anti virus hp smadav
  • jogos download pc completo gratis
  • download comic detective conan free
  • download sum 41 theres no solution
  • download permata yang cari mp3
  • free download maiya yashoda ye tera kanhaiya
  • stfu pries kid ink download
  • go go govinda video download
  • facebook hacker download v2.6
  • download capa de trabalho escolar
  • download winflash to usb
  • download mmorpg for mac
  • o alto da compadecida download gratis
  • winter o golfinho download legendado rmvb
  • download city navigator southern africa nt
  • ingles sin barreras download full
  • i believe nikki download
  • download trailer 2012 movie
  • op com deutsch download
  • spb shell download gratis
  • download creation's end a new beginning
  • download freezing anime episode 7
  • download watermark by enya
  • download sms replicator for android
  • mirela petrean colinde download album
  • download musica quimica do amor
  • stairs to heaven download
  • ell niki running scared download
  • download ghost win 7 da cau hinh
  • download best ringtones 2011
  • download liga i burger fifa 2007
  • zyair g 220 treiber download windows xp
  • imperium civitas 3 download pc
  • good night msg download
  • download saint seiya saison 1
  • download photoshop lightroom 4 free
  • mass effect 3 wallpaper download
  • revit download 2011 portugues
  • free download koko ni iru yo
  • stationery download for mac
  • download economic dictionary mobile
  • taeyeon if download mp3
  • download driver encore n150
  • download fire and desire rick james
  • open office org download for windows
  • download homestuck volume 8 free
  • freya download em partes
  • sakthi kodu song download
  • psicodiagnA?stico v download gratis
  • download dota ai getdota
  • download olvidate de mi
  • kendrick lamar album download free 2012
  • idm download manager trial version
  • download de quebrando regras dublado
  • bleed from within vanity download
  • download doob jaa music video
  • nokia suite download 5530
  • please download apple application support quicktime
  • download usmle road map pathology
  • angry birds download keygen
  • la luna enrico casa rosa download
  • vaquejada de surubim 2012 download
  • a bittersweet life download english
  • download say goodbye anda adam
  • download your shsh blobs from cydia
  • bedrock lil crazed mp3 download
  • download phim bA?ng ma ha?c A?a?ng vn zoom
  • download ta Aa??i danh ba truyan tranh
  • download xanadu olivia newton john
  • rare breed kendrick lamar download
  • canon mp620 scanner download
  • download pentaho data integration 3.2
  • download demo 2012 pes
  • nadia ali embers download mp3
  • h 263 converter free download
  • thula thula mahal mp3 download
  • download eterno pra vocA? hori
  • download starcraft 64 rom
  • pinnacle studio 12 online download
  • sherlock download link tumblr
  • ezgt 2.2 download for windows 7
  • download permanent games for free
  • kizuna no tag download
  • download bloody roar 3 rip
  • download subtitle yamada the samourai of ayothaya
  • download any google book free
  • apex rom download droid x
  • download 320x240 wallpaper pack
  • download one piece 577 3gp
  • get smart movie download free
  • download total annihilation free full version
  • talisman of world download free
  • lisp download for mac
  • download jala & shtela ne pitaj
  • download jerusalem the kings dead
  • download lagu ridin solo jason derulo
  • download mujeres asesinas 1 legendado
  • download grey's anatomy 8x17 rmvb legendado
  • download step up 3 arabseed
  • feuer nursing review download mp3
  • spiegel 2011 download season's
  • download ran private server indonesia
  • download world in conflict soviet assault
  • nancy ajram habibi download
  • download il peggior street album
  • download mystA?re cirque du soleil
  • underworld two months off download mp3
  • shogun 2 sengoku jidai download
  • flash player 10.3 download timeout
  • download para instalar jogos
  • top spin 1 download
  • download qr scanner untuk hp
  • oak ridge boys album download
  • divx v 2.1 player download
  • technomate tm 500 software download
  • free download of electronics projects
  • mix master software download free
  • text processing in python felixxx download
  • art of fighting 3 download
  • free download preet brar new album
  • free download 3110c antivirus software
  • download lagu bop bop baby
  • villain kannada song download
  • evanescence ep a 1998 download
  • download editpad lite for mac
  • download johnny kemp just got paid
  • download lagu reggae kongkalikong
  • handbook of epidemiology download
  • amr diab amarain download free
  • paso i'm the one download
  • m.i.l.k mp3 download yogscast
  • economia para leigos download
  • gals panic s2 game download
  • download netgear wna3100 software
  • download every young man battle
  • ase ole db provider download
  • download video call on facebook
  • download free lose yourself mp3
  • download get lifted john legend
  • christiane f nova geraAA?o download
  • download mp3 pani da rang
  • jonas brothers black keys download
  • ket for schools download
  • download phim madagascar 1 hd
  • download da endorphine magic of the night concert
  • download madcon beggin step up 3
  • download ad aware per vista
  • rihanna unfaithful video download
  • download despicable me vietsub hd
  • drunk and high download
  • download woh humsafar tha lyrics
  • download filme patati patata avi
  • way2sms free download for phone
  • download michael earth song
  • download habbo password cracker
  • free download prince2 study material
  • nokia 2730 bluetooth download
  • cyanogenmod market download was unsuccessful
  • dzwonki na sms download peb
  • pocket tanks download for xp
  • download knife party internet friends vip
  • p money feat. pnc dance with you download
  • download mariah carey 2010
  • free download nokia 6303c games
  • download premade memory stick
  • download wrt54g setup software
  • download dirty old town the pogues
  • download khoon vich garmi garry hothi
  • download spss 17 untuk windows 7
  • the world sings kubota download
  • download video charlie bit my finger again
  • download tv tuner for windows xp free
  • mjht title song video download
  • download dvd esquenta pra balada
  • download imtoo dat converter 6
  • download antivir 64 bit chip
  • download billie holiday the very thought of you
  • hanson where's the love download mp3
  • unrar free download mac os
  • freed from desire 2011 download
  • download station nintendo ds
  • download airstrike 2 gulf thunder free
  • like a g6 download ringtone
  • download filme halloween o inicio rmvb
  • download tamil 3gp comedy videos
  • arch linux 64 bit download
  • download selenium client jar
  • download login yahoo mail
  • download kobi peretz ahava radio edit
  • madalina manole album download zippy
  • download auslogics disk defrag cnet
  • tony igy endorphin mp3 download
  • download portrait professional v8
  • download variante romana 2007
  • download price from yahoo
  • download event to outlook calendar
  • download aplikasi spss 17
  • htc thunderbolt 2.3 download
  • download soal masuk ipdn
  • wamp server zip download
  • download leitor de gp5
  • download dlc tekken tag tournament 2
  • download mp3 astrid saranghamnida
  • download long way down keyshia cole
  • free download zelo walkie talkie for pc
  • 3d max building download
  • rpg maker vx inimigos download
  • ana carolina download problemas
  • download free kurai ondrum illai
  • how to download netflix
  • john carpenter ost download
  • download toby keith whiskey girl
  • free download of durella club rock
  • download stargate empire war pegasus chronicles
  • free download windows 8 omnimo theme
  • owais qadri album download
  • boot camp software download free
  • download sonic 3d blast music
  • reliance huawei ec150 download
  • download night fire movie
  • download nova temporada two and a half men
  • east coast ryders vol 8 download
  • download tier 1 form
  • download map new dota
  • download megavideo on iphone
  • download tamil mp2 songs
  • download bat for lashes the haunted man
  • download rogers yahoo mail
  • borgore relaxation dub download mp3
  • co ed confidential episode 1 download
  • this download is not authorized
  • download what would brian boitano do
  • optimum online download speed slow
  • download limba romana pentru windows xp free
  • download varsham video songs free
  • download skype offline installer 5.5
  • n.e.r.d. don't worry about it download
  • hp printer download j6400
  • er the game 2005 download
  • download the male version of song iktara
  • download effective mysql backup and recovery
  • download latest roster for nba 2k11
  • download metal slug for kawaks
  • download cracked ebooks for iphone
  • zoobi doobi 3gp video download
  • download best player for mac
  • download do filme um caminho de luz
  • free download ajith hits mp3 songs
  • puya vestul download zippy
  • download cole 2 k codec
  • download vbag nokia 6630
  • free download of magician by ice prince
  • download software wep key
  • cheat test hook v0 1 download
  • download w o v varaprasad songs
  • download song ala barfi free
  • download soy un hombre muy honrado
  • download fire of conscience
  • download iron man mp3 black sabbath
  • structured finance and insurance download
  • download anuragathin velayil video
  • hyperion financial reporting download
  • nokia n8 download games 3d
  • adobe photodeluxe download gratis
  • ip surveillance lite download
  • cyanogenmod 7.2 rom download
  • papago x7 malaysia download
  • iatkos v7 iso download link
  • chico buarque vol 3 download
  • download a serious man movie
  • download castle season 3 episode 12
  • utsav songs download free mp3
  • deus ex human revolution download iso
  • download p.s i love you dvdrip
  • download sherlock holmes game of shadows dvdrip
  • solarwinds tftp server download 64 bit
  • download musique projet x
  • download pyar ka pehla khat mp3
  • download creative centrale for zen mx
  • download lagu emha ainun najib mp3
  • driver compaq cq40 xp download
  • civ 5 world builder download
  • o especialista stallone download
  • tina software free download with crack
  • download laungda lashkara of patiala house
  • die frau des zeitreisenden download
  • download un momento by inna
  • iarta ma ovidiu komornyik download
  • download programa passar musica ipod