| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DANP
Thanks Ed, I just got this from MetaLink, looks like you were spot on. A quick check showed me that the offending RBS was more than 2Gb.
Cheers
Lee
Doc ID: Note:100292.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 28-FEB-2000
Last Revision Date: 24-APR-2001
Problem Description
Selecting records from V$ROLLSTAT, you may see that some columns have negative values like HWMSIZE column for example.
Due to [BUG:668924], these columns cannot record values larger than 2GB (2 147 483 647). If the value is greater than that, value turns negative.
This error doesn't prevent Rollback Segment to grow larger than this value. It's just a recording problem in V$ROLLSTAT.
Solution Description
This bug is fixed in 8.0.6 and 8.1.6. You can upgrade to one of these two RDBMS versions to fix the problem. At this point the maximum value will be 4 GB (4 294 967 295).
Workarounds:
Check that no storage option implies in any column a value greater than 2 GB
(like RSSIZE and so HWMSIZE for example).
If so, either alter the storage clause or drop and recreate the rollback segment with a smaller initial size (initial_extent * min_extents).
If you don't want negative values to appear in rssize, writes, hwmsize, at any moment, set max_extents to the right value.
Warning : Doing so, you will prevent success of transactions generating more
than 2GB of undo. So you should probably modify such transactions.
2. Negative values will disappear at next instance start if not initial storage
values.
As v$rollstat is a dynamic performance table which is reset at each instance
start, at next instance start negative values will disappear if these
negative
values are not due to initial size of Rollback Segment.
-----Original Message-----
Sent: 10 December 2001 15:10
To: Robertson Lee - lerobe; ORACLE-L_at_fatcity.com
Sorry Lee,
I made a mistake. I was looking through russian confs. It seems it appears when size of your rollback segment is more than 2Gb.
Regards,
Ed
> Thanks for the reply Ed, but my db_block_size is 8k.
>
> Regards
>
> Lee
>
>
> Hi Lee,
>
> if my memory serves me right it's somehow connected with db_block_size (a
> bug I suppose).
> Your db_block_size is less than 8K isn't it?
>
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: lerobe_at_acxiom.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Dec 10 2001 - 09:54:29 CST
 |
 |