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
