Hi,
In a book I read that DBWO writes dirty data buffers from data buffer cache
to the data files. I would appreciate if someone could kindly clear my
confusion.
What is meant by dirty data buffers? If these are dirty (not good/healthy)
why to write to these to data files?
TIA!
Aleem
--
:
Sent by: Subject: what is meant by dirty
buffers
[EMAIL PROTECTED
This buffers are changed by Oracle in memory only (in cache), so they are
different from the blocks on disk Therefore, they must be written to disk,
after which they are not dirty any more. That's how oracle makes changes to
speed up the process - everything is done in memory first, then written
i am not too sure but i think dirty means that the data that is written to
the data files mite also be obsolete. This means that the data has already
been deleted from the database yet it is written into the file. This is
similar to what people call a dirty read in informix cursors where the data
Aleem,
A dirty buffer is a data block that has been changed by a user. When a user
selects/updates/deletes from a table, the data from that table is pulled in to the
buffer cache, where it can then be manipulated.. If a user selects for update, and
then updates that data it is then known as
Yeah, Oracle always has at least two names for the same thing. Dirty = Modified.
Alexandre Gorbatchev wrote:
This buffers are changed by Oracle in memory only (in cache), so they aredifferent from the blocks on disk Therefore, they must be written to disk,after which they are not dirty any
completely wrong. that's not a case in oracle.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 2:13 PM
i am not too sure but i think dirty means that the data that is written to
the data files mite also be obsolete. This