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
Printable View
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
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.
all kind of data is written, comitted and uncomitted
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.