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: Leyi Zhang (Kamus) <kamusis_at_gmail.com>
Date: Tue, 14 Mar 2006 17:49:19 +0800
Message-ID: <94b9f9d00603140149o15038204nd6d08f02431bf78b@mail.gmail.com>


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_at_trivadis.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Kamus <kamusis_at_gmail.com>

Oracle8i & 9i Certified DBA from China

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 14 2006 - 03:49:19 CST

Original text of this message

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