From: Jonathan Lewis <>
Date: Wed, 27 Feb 2008 20:54:04 -0000
Message-ID: <>

"Dereck L. Dietz" <> wrote in message news:Xbpwj.12475$
> Oracle
> 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?

There is a flaw in that question.
What do you mean by the process "stopped" ?

Do you really mean that the process seems to have stopped because it takes much longer than you expect ?

Have you checked v$session_wait and v$session_event for the process to see where it is accumulating time (if it is still alive).

If the log files are very small and lgwr and dbwr are having trouble keeping up with the workload, the session might spend a lot of time waiting on
  log buffer space
  log file sync
  write complete wait
and various waits relating to checkpoint incomplete (but, as another poster pointed out, these would be recorded in the alert log).


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Wed Feb 27 2008 - 14:54:04 CST

Original text of this message