Re: Archiving of Redo Logs Growing Tremendously

I would rephrase that slightly. Users! Can't live with them .... pass the beer nuts.

Brian E Dick wrote:

>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 - 15:07:49 CST