RE: DBA Humor (Twisted, sick sort of stuff...)

From: Grabowy, Chris <chris.grabowy_at_lmco.com>
Date: Wed, 27 Mar 2013 18:16:28 +0000
Message-ID: <5AF7D9F949ABC9479BC438A53649B536385B208B_at_HDXDSP51.us.lmco.com>



Perhaps it would be best to stop this conversation now....an Oracle Sales rep might be on the list and get some new ideas..............

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net Sent: Wednesday, March 27, 2013 2:02 PM
To: oralrnr_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: EXTERNAL: RE: DBA Humor (Twisted, sick sort of stuff...)

yes processing lots of data several times a day as they re-test. Just humorous when your redo generated surpasses the actual application data.

Chris

From: Orlando L [mailto:oralrnr_at_gmail.com] Sent: Wednesday, March 27, 2013 12:57 PM To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org
Subject: Re: DBA Humor (Twisted, sick sort of stuff...)

I dont know about this particular application, but I would think there are some applications which would generate huge amounts of redo? Can someone share their thoughts.

You have have mentioned that they are doing testing. Could they be loading large volumes of data?

Funny thing happened today.
Database backup for one of my development databases failed last night due to a space issue. While fixing that issue today, we received an alert that the archivelog space was filling up.

Now, having sized these things fairly well, and not having these issues before, I started poking around (of course).

We're under some pretty tight deadlines right now and some of our devs were being really aggressive with their testing.

In the last 1.5 days we've generated over 500GB of archivelogs in this development instance.

Here's the kicker/humor:

The schema data itself is only 300GB! LOL (Personally, I thought that was funny)

So I asked the devs to modify what they're doing and to let me know what they need - if they really need to be doing this testing, we'll get the space they need.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 27 2013 - 19:16:28 CET

Original text of this message