Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DWBR and dirty buffers

Re: DWBR and dirty buffers

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 27 Feb 2005 19:42:07 -0800
Message-ID: <1109562127.441969.265490@g14g2000cwa.googlegroups.com>


Jonathan Lewis wrote:
> Notes in-line
>
> >
>
> It might be easiest to report the objd column
> from v$bh - values around 4 billion are rollback
> segments, values between 4 million and 4 billion
> are temp tables. Values less than about 5000
> are probably data dictionary or other SYS
> tables.

Did this and found out it was updated indexes that got the dirty=Y, status=xcur.
Plus a few undo segments as expected.

>
> If that's not the answer, it may be a specific
> RAC thing, and I would take it up with Oracle -
> after all, it's a bit of a threat to recovery if
> you XCUR dirty blocks that never get cleaned.
> In principle it means you could overwrite a log
> file that should not have been overwritten.

I've passed the findings to the project's dba. Can't go over his head to Metaclick, it's his turn now to take action.

Thanks for helping to identify the problem. Received on Sun Feb 27 2005 - 21:42:07 CST

Original text of this message

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