Re: LGWR and DBWR
From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 25 Feb 2008 04:33:03 -0800 (PST)
Message-ID: <dea0a8c0-5721-4e99-a19e-dcc793fe60a3@z17g2000hsg.googlegroups.com>
Date: Mon, 25 Feb 2008 04:33:03 -0800 (PST)
Message-ID: <dea0a8c0-5721-4e99-a19e-dcc793fe60a3@z17g2000hsg.googlegroups.com>
On 25 feb, 02:52, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows 2003 Server
>
> Is it possible for improperly sized redo log files to be overwhelmed to the
> point where it will cause a process which is performing a lot of writes to
> multiple tables to stop processing without any error or reason in a log
> file?
No.
With overwhelmed redo logfiles the error in the alert logfile would be:
Thread 1 cannot allocate new log, sequence 50776 Checkpoint not complete Received on Mon Feb 25 2008 - 06:33:03 CST