Developers and DBAs

1
Developers and DBAs

• An Epic Story

2
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.

3
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.

4
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.

5
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.

6
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.

7
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!

8
Beginning of the End

• But Sir DBA and Developera didnt 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.

9
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.

10
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