Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datafiles & redo log files on the same disk

redologgerMar 21 2012 — edited Mar 28 2012
hi guys,

http://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo002.htm#i1306224

>

Datafiles should also be placed on different disks from redo log files to reduce contention in writing data blocks and redo records.
>

I am really thinking whether is there actually any contention when first of all oracle can only writes to 1 redo log files at a time.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo001.htm
>
Oracle Database uses only one redo log files at a time to store redo records written from the redo log buffer. The redo log file that LGWR is actively writing to is called the current redo log file.
>

so the process flow i got after reading this chapters is that

when LGWR fills up a redo log file ( the redo records) then there will be a log switch + checkpoints where the writing to the data blocks occur. There seem to be a serial flow rather then a concurrent kind of flow. So i don't really get it when it mention there will be contention when both datafiles and redo records writing which is the redo log file are on the same disks.

Just to confirm with you guys whenever there is a log switch a checkpoint will occur too right.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo002.htm? U can seach checkpoint to jump to the section it mention from this documentation.
This post has been answered by jgarry on Mar 21 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2012
Added on Mar 21 2012
11 comments
990 views