My former boss, and current friend, bought an Android phone for himself and his wife last week and asked me for a list of my must-have apps. I’ll list them here for the morbidly curious, but that got me thinking – what are my must-have scripts for managing my Oracle database? I know we’re supposed to use they ‘tool’ things, but I seriously doubt any real DBA relies 100% on what a pretty console screen tells them. DBAs collect scripts like that guy John Cusack played in Fidelity collects records.
If I were to put the pager-holster back on tomorrow in production land, what ‘bullets’ would I have loaded for an emergency? What jobs would I have running to keep things in shape? Here’s a few that I came up with and-or remembered from using ‘back-in-the-day.’
Oracle Scripts to Keep Me Warm at Night
Help me out real DBAs, what are the routine things you do every day via script? Disclaimer: Your ideas might end up in my presentations/demos as use cases!
Oh yeah, here’s my ‘must-have’ list of apps for Android: