RE: Will dump block make dirty block written to disk?
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- Date: Mon, 13 Mar 2006 15:59:11 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
