DBWR, LGWR, CKPT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBWR, LGWR, CKPT

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    10
    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.

    Thanks



  2. #2
    Join Date
    Sep 2000
    Posts
    23
    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