Look in:

Web oracle-core-dba.blogspot.com

Saturday, June 08, 2013

Life of DBA

 
 It's been a long time since I had put something here, I will try and start over again. 
Btw enjoy reading a poem which almost every dba can relate himself/herself to.
Life of DBA
A Small Poem which is describing the life of a DBA in a good way

Source : Steven Karam

Late at night at the office, Im the only one there
Many new tasks to get done, lots of things to repair.
While setting up some table grants, to keep security tight
My head grew heavy and my sight grew dim
I want to stop for the night
There it was on the display;
A piece of query hell
And I was thinking to myself
Lets give up Oracle and just go Excel
But I made a new index, and I started to pray
For an ending to the query war,
That it would end today

Welcome to the life of DB Admins
Fix the database
At an urgent pace
Always at work in the life of DB Admins
Any time of year, you will find us here.

Their queries dont use indexes, and the, where clause never ends (uh)
They got a lot of inefficient joins no DBA recommends.
How they fill up the ORDER BY, disk sorts galore
And then for no reason, they add even more.

So I grow the PGA
Hoping sorts will decline
But then I have to free up some more RAM from my well planned design
And now theres more full table scans, tons more each day.
With every new line of code that they write
I feel more dismay.

Welcome to the life of DB Admins
Fix the database
At an urgent pace
Living to work in the life of DB Admins
What a nice surprise, loads are on the rise.

CBO is reeling,
Gathered stats once or twice
And I thought, maybe I should just query for some DB_CACHE_ADVICE,
Or Ill add a new MView,
Hints are last but not least
Ill do anything I can do
Until disk reads have all ceased.

Last thing I remember, I was
Looking to explore
A way to get the whole server
Off the rack to smash to the floor
Relax, said my manager,
Though the code does make you grieve.
You still have a lot of work to do,
Get it done or youll never leave!

No comments: