Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> system rollback segments
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 MBWATER(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
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 toanother