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

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: Christopher.Taylor2@xxxxxxxxxxxx
  • Date: Wed, 27 Mar 2013 13:14:43 -0500

A couple of times I have run into process tracking systems that write a
row, update this row 30 or 50 or 100 times, then delete the row.  typically
in the same day.  And they dont even need to keep the data, but the systems
are invariably in archive log mode because this is a 'best practice'.
On Wed, Mar 27, 2013 at 1:01 PM, <Christopher.Taylor2@xxxxxxxxxxxx> wrote:

> 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
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


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

Other related posts:

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