Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!proxad.net!proxad.net!62.253.162.218.MISMATCH!news-in.ntli.net!newsrout1-win.ntli.net!news-out.ntli.net!newsrout1-gui.ntli.net!ntli.net!pe1.news.blueyonder.co.uk!blueyonder!text.news.blueyonder.co.uk!53ab2750!not-for-mail From: "Dave" Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc References: <7p82011a3jhh1ev2v456utq7ncq9kn4o3u@4ax.com> Subject: Re: system rollback segments Lines: 74 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: Date: Wed, 02 Feb 2005 20:04:08 GMT NNTP-Posting-Host: 82.39.105.121 X-Complaints-To: abuse@blueyonder.co.uk X-Trace: text.news.blueyonder.co.uk 1107374648 82.39.105.121 (Wed, 02 Feb 2005 20:04:08 GMT) NNTP-Posting-Date: Wed, 02 Feb 2005 20:04:08 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234833 comp.databases.oracle.misc:116139 "Vince Laurent" wrote in message news:7p82011a3jhh1ev2v456utq7ncq9kn4o3u@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