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

Home -> Community -> Usenet -> c.d.o.misc -> Re: system rollback segments

Re: system rollback segments

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 02 Feb 2005 23:02:51 +0100
Message-ID: <ctrijb$thb$1@news1.zwoll1.ov.home.nl>


Dave wrote:

> "Vince Laurent" <vincelaurent_at_REMOVETHISsbcglobal.net> wrote in message 
> news:7p82011a3jhh1ev2v456utq7ncq9kn4o3u_at_4ax.com...
> 

>>I moved our system to undo from rollback but I keep seeing messages
>>from our monitoring software like the following. Why are there
>>rollback segements in the system tablespace? Why did I get a warning
>>the other day that there was 1 offline, then the day after 2, now
>>there is 3? Where are they coming from? We are running Oracle 9.2.0.4
>>on HPUX 11i
>>
>>Output :
>> Report For Database
>> Wed Feb 2 10:29:09 2005
>> Metric RBSegmentStatus (0067 / 0068)
>>
>> SIZE OPTIMAL
>>HIGH # OF # OF # OF AVG SIZE
>>NAME STATUS IN MB IN MB
>>WATER(MB) SHRINKS WRAPS EXTENDS ACTIVE EXTS
>>------------------------------ --------------- --------- ---------
>>--------- -------- -------- -------- -----------
>>_SYSSMU1$ OFFLINE
>>_SYSSMU12$ OFFLINE
>>_SYSSMU13$ OFFLINE
>>SYSTEM ONLINE 0.77
>>0.77 0 1 0 8192
>>_SYSSMU2$ ONLINE 60.12
>>196.12 99 953 580 1568928
>>_SYSSMU3$ ONLINE 80.12
>>278.12 122 1030 744 2738994
>>_SYSSMU4$ ONLINE 88.12
>>280.12 113 993 660 3003202
>>_SYSSMU5$ ONLINE 55.12
>>232.12 105 1093 589 1303087
>>_SYSSMU6$ ONLINE 63.12
>>300.12 125 1039 741 1215720
>>_SYSSMU7$ ONLINE 72.12
>>280.12 109 968 709 1500078
>>_SYSSMU8$ ONLINE 56.12
>>200.12 87 862 538 1311343
>>_SYSSMU9$ ONLINE 128.12
>>296.12 126 1068 768 13602862
>>_SYSSMU10$ ONLINE 55.12
>>288.12 95 867 598 1207489
>>_SYSSMU11$ ONLINE 64.12
>>224.12 103 991 686 3159643
>>
>>NAME: Rollback segment name
>>STATUS: ONLINE, OFFLINE PENDING (going offline but some
>>transactions are
>> pending), OFFLINE
>>RSSIZE: Size in MB of rollback segment
>>HWMSIZE: High-water mark of rollback segment size
>>OPTSIZE: Optimal size of rollback segment
>>SHRINKS: Number of times rollback segment shrank, eliminating
>> one or more additional extents each time
>>WRAPS: Number of times rollback segment wraps from one extent to
>>another
>>EXTENDS: Number of times rollback segment was extended to have a new
>>extent
>>AVEACTIVE: Current average size of active extents, where "active"
>>extents have uncommitted transaction data
>>
>>
>>-----------------------------------------------------
>>Come race with us!
>>http://www.mgpmrc.org
> 
> 
> system rollback segment is always in the system tablespace
> 
> oracle constantly onlines and offlines rollback segments so its not a 
> problem, you need to update your monitoring software to understand 9i 
> 
> 

An no - it is *NOT* a good idea to offline that one... It's used internally by DDL statements, afaik And by the time you understand 9i, you do not need this monitoring s/w... :)
-- 
Regards,
Frank van Bortel
Received on Wed Feb 02 2005 - 16:02:51 CST

Original text of this message

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