Re: REDO LOG SPACE REQUESTS

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 21 Apr 2003 19:08:31 -0700
Message-ID: <1b061893.0304211808.43e3501a@posting.google.com>

From Oracle:

Number of times the active log file is full and Oracle must wait for disk space to be allocated for the redo log entries. Such space is created by performing a log switch.

Log files that are small in relation to the size of the SGA or the commit rate of the work load can cause problems. When the log switch occurs, Oracle must ensure that all committed dirty buffers are written to disk before switching to a new log file. If you have a large SGA full of dirty buffers and small redo log files, a log switch must wait for DBWR to write dirty buffers to disk before continuing.

Also examine the log file space and log file space switch wait events in V$SESSION_WAIT

HTH Daniel Received on Mon Apr 21 2003 - 21:08:31 CDT