RE: Database performance monitoring tool for developers.

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Fri, 18 Apr 2003 02:56:42 -0800
Message-ID: <F001.00584B2E.20030418025642@fatcity.com>

My philosophy exactly. I try never to make the same mistake twice, that's boring :) I say to people "I will tell you when I mess up because if I do, when I tell you that this time it isn't me, you'll believe me"

True story:

one day early on in my DBA days, I was working on both the dev and production database on two different terminals (back in the dumb terminal days on a VAX). Same database. Same tablespace names. I was dropping and recreating the DEV app. Two tablespaces, one static data, one dynamic. To save time (I thought), I did "alter tablespace <dynamic> offline; drpop tablespace <dynamic> including contents" on one and the same commands for the static tablespace on the other. After I hit send (why you never realize it beforehand I don't know), I realized that the static one I dropped was production.

I went into the app manager, my exact words were "you can kill me later, this is what I did, how do you want to go about fixing it".

Fortunately we had a cold backup from the night before and could rerun the batch.

Never made that mistake again.

• Cary Millsap <cary.millsap_at_hotsos.com> wrote:
  > One more thing while I'm kind of on the topic... Guys, my ratio of
  > screw-ups
  > to attempts is as high as anyone's. But the fastest I've ever learned
  > has
  > been by paying attention to those screw-ups, calling them what they
  > were,
  > and then for heaven's sake writing them down so I could remember
  > them. And
  > in fact so that other people can remember them too. Hiding them helps
  > no
  > one.
  >
  > There should be no actual shame in screwing up if the attempt is
  > honorable,
  > and if you're not making the same dumb mistake a second or third
  > time. I
  > think there's a big difference between "I am an idiot" and "I on
  > occasion
  > have done idiotic things." The cemeteries are full of people who
  > didn't
  > learn from their own mistakes...
  >
  >
  > Cary Millsap
  > Hotsos Enterprises, Ltd.
  > http://www.hotsos.com
  >
  > Upcoming events:
  > - Hotsos Clinic 101 in London, Reykjavik, Ottawa, Denver, Sydney
  > - Visit www.hotsos.com for schedule details...
  > - IOUG-A Live 2003, Orlando, 10am Monday 28 April: "Oracle
  > Operational
  > Timing Data"
  

  ---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo http://search.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Apr 18 2003 - 05:56:42 CDT