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