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

  • From: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
  • To: Christian.Antognini@xxxxxxxxxxxx
  • Date: Tue, 14 Mar 2006 17:49:19 +0800

Use bbed or dump or oradebug, even dual make us feel so cool... but oracle
database itself always provide us more easier method to resolve the same
problem :)

On 3/14/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
Kamus <kamusis@xxxxxxxxx>

Oracle8i & 9i Certified DBA from China

Other related posts: