Re: Archiving of Redo Logs Growing Tremendously

Hi Eileen,

Life would be so boring if not for users, kids and David Bowie ;)

Even when users are not to blame, it doesn't hurt blaming them anyway.

Cheers

Richard
"Eileen Ong" <eileen_ong_at_abacus.com.sg> wrote in message news:apsn4o$29o$1_at_nobel.pacific.net.sg...
> Hi,
>
> We have found out the problem. It was to do with user putting lots of
> erroneous data into some of the tables.
>
> Thanks for all the replies. Appreciate your help!
>
> Cheers
> Eileen
>
> --
>
> "Basil Jackson" <BJackson_at_BOSGmbH.Com> wrote in message
> news:adec38b6.0210250533.2b6ba8c0_at_posting.google.com...
> > I once had a similar problem which was caused by a job that was
> > scheduled to clean out old records. Unfortunately, due to a situation,
> > there was one particular portion of the job which would fail after
> > having done a lot of work (and creating a lot of redo). Because the
> > job failed (without generating an error message by the way) the actual
> > work still needed to be done and the next time the job ran, it would
> > again generate all that redo.
> >
> > When it happened, I was just as much at a loss to explain it as you
> > are now. Nothing had changed and it had always worked before...
> > However, the situation had changed. The data was what was causing it
> > and not an update to the software, etc.
> >
> > Perhaps you're experiencing a similar situation.
>
>
Received on Fri Nov 01 2002 - 06:48:48 CST