Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Will dump block make dirty block written to disk?

RE: Will dump block make dirty block written to disk?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 13 Mar 2006 15:59:11 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5569@MSXVS04.trivadis.com>


Leyi

>I've been told another most simple method to get the answer.
>Check the v$bh.dirty, if Y means still dirty, if N means
>written to disk already.

This is possible. The problem I see is that in the buffer cache you may have multiple versions of the same block. Some of them with the flag DIRTY set to N, some other with Y. Therefore, to be sure, I prefer to directly get this information from the datafile.

Regards,
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 13 2006 - 08:59:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US