RE: DBA Humor (Twisted, sick sort of stuff...)
Date: Wed, 27 Mar 2013 13:01:32 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879B7DE29F_at_NADCWPMSGCMS10.hca.corpad.net>
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-lReceived on Wed Mar 27 2013 - 19:01:32 CET