DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2000
    Question about DBWR, LGWR and Checkpoint:

    1. DBWR writes dirty buffers from the data buffer cache to data files
    2. LGWR writes the redo log buffer to the active online redo log files
    3. Checkpoint occurs when log file is full and then DBWR do what need to do (1)
    According Oracle documentation: ‘If DBWR process has not finished checkpoint a file and LGWR needs the file again, LGWR has to wait’.
    I do not understand why LGWR needs to wait because LGWR works with log files and DBWR works with data files.


  2. #2
    Join Date
    Sep 2000
    I guess is that LGWR write the log files but read datafiles, you already said, if LGWR needs the file...,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.