Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Archiving of Redo Logs Growing Tremendously

Re: Archiving of Redo Logs Growing Tremendously

From: Brian E Dick <bdick_at_cox.net>
Date: Fri, 01 Nov 2002 14:23:30 GMT
Message-ID: <C7ww9.71357$gA1.2262301@news2.east.cox.net>


Users! Can't live with them. Can't live without them.

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:_Ftw9.67171$g9.189116_at_newsfeeds.bigpond.com...
> 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 - 08:23:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US