OPTIMAL size for rollback segment in Oracle 8i
614938May 14 2008 — edited May 25 2008In our Database we have 13 Rollback segments & total size of all rollback segments is 33gb.
Used % it is showing 99.84%.
each rollback segment having near around 4gb of size.
I am in confusion to set OPTIMAL value for each rollback
segment.
can any one help me out reg this.
My roll back seg statistics are as fallows:
SEGMENT_NAME TABLESPACE_NAME WAITS SHRINKS WRAPS STATUS
------------------------------ ------------------------------ ---------- ---------- ---------- -------
R00 SYSTEM 0 0 12 ONLINE
RBS0 RBS 0 0 19 ONLINE
RBS01 RBS 0 0 16 ONLINE
RBS02 RBS 1 0 12 ONLINE
RBS03 RBS 0 0 11 ONLINE
RBS04 RBS 0 0 21 ONLINE
RBS05 RBS 1 0 22 ONLINE
RBS06 RBS 0 0 16 ONLINE
RBS07 RBS 0 0 15 ONLINE
RBS08 RBS 0 0 12 ONLINE
RBS09 RBS 1 0 19 ONLINE
SEGMENT_NAME TABLESPACE_NAME WAITS SHRINKS WRAPS STATUS
------------------------------ ------------------------------ ---------- ---------- ---------- -------
RBS12 RBS 0 0 13 ONLINE
RBS13 RBS 0 0 18 ONLINE
SYSTEM SYSTEM 0 0 0 ONLINE