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: Dave <x_at_x.com>
Date: Wed, 02 Feb 2005 20:04:08 GMT
Message-ID: <YmaMd.5694$8B3.173@text.news.blueyonder.co.uk>

"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 Received on Wed Feb 02 2005 - 14:04:08 CST

Original text of this message

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