Re: Archiving of Redo Logs Growing Tremendously

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.