Friday, February 13, 2009

Life of a DBA

It was a dark and stormy night
The winds rampaged asunder;
To the world was born a DBA
It was a miracle, a wonder!

As he grew up, a thoughtful child
He recorded every session,
Of life, of love, of moments true,
Every guilt and confession.

His parents spotted his charming habit
Of cloning instances;
For he had the temper of his father
And the face of his mother
With minor version changes.

Every sysdate of his early life
Was spent in performance tuning,
His superior user environment parameters
Had the women swooning.

For he was handsome, charming and nice
And his pockets were full of money.
His cost based optimizer ensured
That his days were always sunny.

Then once day his calling came
And he leaped to join the forces,
Of the exalted men and women
Who make Tables, indexes and sequences.

He copied data from schema to schema
And cleared the buffer cache.
His queries never had full table scans
His joins were always hash.

Thus progressed the perfect life
Till he was sent onsite,
The world proclaimed the mighty DBA
Had finally arrived.

This is where our DBA
Was laptoped and anointed
He was on call for a week each month,
His slumber was to be disappointed.

For every time he dozed off at night
The environment would act on its whim;
His troubleshooting skills were tested
SLA's were second nature to him.

Loading data, procedures and packages
Synonymns triggers and indexes,
He partitioned the diskspace and granted privileges
The watermark levels were never in excess.

Thus our DBA labored on
With only his work in sight,
He never noticed the pretty programmer
Seated to his right.

They never met, they never spoke
Though one cube did they infest
For when she turned to him, he was just a number:
Issue, Remedy or Change Request.

Then one day, our DBA
Set his eyes on her and rested his case,
Love fluttered like a silent beast
And filled up his tablespace.

He queried after her alright
He committed with autosave,
In his heart's rowid
Her name did he engrave.

But she implored him to rollback
For she was besotted to another,
He dealt with pointers, methods and classes
A Sun certified Java Developer.

In grief, he tried to kill v$session
And delete the audit trails,
Meanwhile he prepared to format the hard drive
For they say it never fails.

Our story ends here so far
For when database there was no more,
Our DBA's contract was terminated
They sent him packing back offshore.