oncheck -cD errors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas J. Girsch - 27 Aug 2007 04:36 GMT

All:

I'm seeing bazillions of these errors on some tables when I run oncheck -cD:

WARNING: data page 0xe495 in tablespace 0x4f00002 appears to be

more or less full than is indicated in the bitmap.

Bitmap mode: 0xc, Calculated mode: 0x4.

WARNING: The bitmap mode for page 0xe495 has been reset from 0xc to 0x4.

Anything to worry about?

Thanks,

- TJG

Reply to this Message

Art S. Kagel - 27 Aug 2007 16:57 GMT

On Aug 26, 11:36 pm, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com>
wrote:

> All:
>
[quoted text clipped - 13 lines]
>
> - TJG

Not a real problem. The oncheck repaired the damage. Could be that a
crash or non-standard shutdown in the past caused modified bitmap
pages to not be flushed to disk.

Art S. Kagel

Reply to this Message

Thomas J. Girsch - 28 Aug 2007 05:19 GMT

> Not a real problem. The oncheck repaired the damage. Could be that a
> crash or non-standard shutdown in the past caused modified bitmap
> pages to not be flushed to disk.
>
> Art S. Kagel

I can't imagine that would be it. It occurred for nearly every record
in a table with millions of rows. But I've heard other reports that
it's nothing to worry about unless it persists.

Thanks,

- TJG

Reply to this Message

bozon - 28 Aug 2007 16:28 GMT

On Aug 28, 12:20 am, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com>
wrote:

> > Not a real problem. The oncheck repaired the damage. Could be that a
> > crash or non-standard shutdown in the past caused modified bitmap
[quoted text clipped - 9 lines]
>
> - TJG

You don't have 2 instances sharing the same space do you? Otherwise I
agree with what you have heard.

Reply to this Message

Art S. Kagel - 28 Aug 2007 17:18 GMT

On Aug 28, 12:20 am, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com>
wrote:

> > Not a real problem. The oncheck repaired the damage. Could be that a
> > crash or non-standard shutdown in the past caused modified bitmap
[quoted text clipped - 5 lines]
> in a table with millions of rows. But I've heard other reports that
> it's nothing to worry about unless it persists.

But each bitmap page describes over 4000 pages and depending on
pagesize and rowsize a single bitmap page can affect more than
10million rows!

Art S. Kagel

Reply to this Message