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

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <oralrnr@xxxxxxxxx>
  • Date: Wed, 27 Mar 2013 13:01:32 -0500

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@xxxxxxxxx]
Sent: Wednesday, March 27, 2013 12:57 PM
To: Taylor Christopher - Nashville
Cc: oracle-l@xxxxxxxxxxxxx
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.

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013