Dirty buffers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Dirty buffers

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    does DBWR write only commited dirty buffers which are commited to the hard disk from db buffer cache or is there any situation when dbwr writes uncommited dirty buffers into hard disk

    regards
    sonia

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    What would be the use in writing the same data from memmory which already exists on disk, it would be inefficient and a waste of an I/O trip.

    No only dirty buffers are written to disk.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    all kind of data is written, comitted and uncomitted

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    If there isnt enuf DB Buffer then Oracle writes Dirty Buffers to the Disk. It takes care of consistency with the help of Redo Logs and RollbackSegments.

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