Oracle-L: RE: what is meant by dirty buffers

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 13 May 2002 04:18:22 -0800
Message-ID: <F001.0045F340.20020513041822@fatcity.com>

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 "dirty" - or in simpler terms "changed", and should be written to disk (physical) storage, instead of being kept in memory (or the buffer cache).

HTH Mark

-----Original Message-----
Sent: 13 May 2002 12:43
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
INET: dmit_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------