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

Hi Mark

>Correct me if I'm wrong, Chris, but unless I misunderstand something,
>"dirty" only really means something in the context of the block in
>current mode, of which there can be only one in the buffer cache at any
>time. So, the consistent read copies should just be ignored.
>
>So, something like:
>select file#, block# from v$bh where status = 'xcur' and dirty='Y';
>
>should show you the list of dirty blocks in the cache....right?

Good point. You are right.
In this way it's very simple to differentiate them.

I'm probably too fast in using BBED because I simply like it! And, in addition, in the last months I spent so much time with it that I forgot what the database can do ;-)

Thanks,
Chris

--
http://www.freelists.org/webpage/oracle-l