Re: DANP
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? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: 1. Check Storage Clause 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DANP
Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee -Original Message- Sent: 10 December 2001 12:40 To: Multiple recipients of list ORACLE-L 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? Regards, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 2:55 PM > All, > > Oracle 8.0.5.0.0 on Tru64 Unix v4.0f > > Anyone seen anything like this before ?? I've never seen a negative number > before. I'm assuming its a bug/"feature" > > Regards > > Lee > > > > TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK > > MINX NUMXMAXX SHRINAVACTK > > -- --- --- --- - - - > > --- - - > > RBSRBS05ONLINE81920 81920 1064952 1064952 > > 2 13 505 0 0 > > RBSRBS06ONLINE81920 81920573432 573432 > > 27 505 0 0 > > RBSRBS07ONLINE81920 490952-1490952 > > 2 33 505 0 0 > > RBSRBS08ONLINE81920 81920 1720312 1720312 > > 2 21 505 0 0 > > SYSTEM SYSTEM ONLINE 56 56 392 392 > > 25 505 0 0 > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DANP
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? Regards, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 2:55 PM > All, > > Oracle 8.0.5.0.0 on Tru64 Unix v4.0f > > Anyone seen anything like this before ?? I've never seen a negative number > before. I'm assuming its a bug/"feature" > > Regards > > Lee > > > > TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK > > MINX NUMXMAXX SHRINAVACTK > > -- --- --- --- - - - > > --- - - > > RBSRBS05ONLINE81920 81920 1064952 1064952 > > 2 13 505 0 0 > > RBSRBS06ONLINE81920 81920573432 573432 > > 27 505 0 0 > > RBSRBS07ONLINE81920 490952-1490952 > > 2 33 505 0 0 > > RBSRBS08ONLINE81920 81920 1720312 1720312 > > 2 21 505 0 0 > > SYSTEM SYSTEM ONLINE 56 56 392 392 > > 25 505 0 0 > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
