+ Reply to Thread
Results 1 to 4 of 4

Thread: Dirty buffers

  1. 06-05-2002 04:56 AM #1
    Sonia
    Sonia is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 06-05-2002 05:16 AM #2
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  3. 06-05-2002 05:52 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    all kind of data is written, comitted and uncomitted
    Reply With Quote Reply With Quote
  4. 06-05-2002 03:00 PM #4
    patnams
    patnams is offline Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width