developers and dbas an epic story. all hail the dba once upon a time, there was a knight, and his...
TRANSCRIPT
Developers and DBAs
An Epic Story
All Hail the DBA
Once upon a time, there was a knight, and his name was Sir DBA.
Sir DBA was a man of honor, vision, and index maintenance. He vanquished bad queries and high loads every day and night.
The Mission
One day, Sir DBA learned of a princess in peril. He resolved to help her, for if assisted she would provide high corporate earnings, low database loads, and faster query results.
0
50
100
Q1 Q2 Q3 Q4
NoPrincess
Princess
*gasp*
Sir DBA rode to the castle where the princess was to be found, but was stopped by the evil Developera.
Developera was a horrible witch who cast evil code and destroyed databases.
The Battle
Sir DBA pulled out his keyboard in order to vanquish this foe. The evil witch Developera used her magical mouse to retaliate with bad queries and long running processes.
The Fight Rages On…
Developera cast a horrible query of many lines and little where clause criteria which Sir DBA countered with an index to improve query performance.
Using her abilities, she laid down thirty of the same query with different values and no bind variables, which Sir DBA valiantly fought off with the CURSOR_SHARING parameter.
But then…
They never noticed the Princess watching them in sadness.
She pleaded with them, “If you would but work together, teach each other, we could get all of this resolved much easier!”
Beginning of the End
0
10
20
Then Now
Team Effectiveness
But Sir DBA and Developera didn’t listen. They continued to fight, to point fingers, and to do battle. They never stopped to work together. The kingdom suffered greatly during this time.
Finally…
The Princess finally decided she was fed up with Sir DBA and Developera.
She hired consultants who understood that communication got things done. They shared their knowledge with each other so that all would benefit and there would be a minimal amount of finger pointing.
The End of an Era
The Kingdom went on to achieve high revenue with a significant decrease in downtime and an increase in customer satisfaction. And they lived happily ever after.
THE END