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