SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:16 PM
| ||||
| ||||
 oncheck -cD errors 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      |
|
04-20-2008, 04:16 PM
| |||
| |||
| Re: oncheck -cD errors On Aug 26, 11:36 pm, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com> wrote: > 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 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 |
|
04-20-2008, 04:17 PM
| |||
| |||
| Re: oncheck -cD errors Art S. Kagel 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 > 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 |
|
04-20-2008, 04:17 PM
| |||
| |||
| Re: oncheck -cD errors On Aug 28, 12:20 am, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com> wrote: > Art S. Kagel 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 > > 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 You don't have 2 instances sharing the same space do you? Otherwise I agree with what you have heard. |
|
04-20-2008, 04:17 PM
| ||||
| ||||
| Re: oncheck -cD errors On Aug 28, 12:20 am, "Thomas J. Girsch" <tgir...@NOSPAM.gmail.com> wrote: > Art S. Kagel 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 > > 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. 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 |
Linear Mode
