Re: Archiving of Redo Logs Growing Tremendously

In article <C7ww9.71357$gA1.2262301_at_news2.east.cox.net>, "Brian says...
>
>Users! Can't live with them. Can't live without them.

On the other hand, I would have no difficulty living without David Bowie!

Sorry, Richard, couldn't resist!

Pete
>
>"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.
>> >
>> >
>>
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Nov 01 2002 - 12:01:05 CST