RBS WRAPS VS EXTENDS??

From: dULcE <cajigas-dl_at_ncspi.nec.co.jp>
Date: Mon, 22 Jan 2001 13:59:23 +0800
Message-Id: <10748.127232@fatcity.com>

Good Day!!

I've been monitoring my rollback segments and i've noticed that we have WRAPS but no extensions.

SQL> col Name format a20
SQL> select Name, optsize, shrinks, aveshrink, wraps, extends 2 from V$ROLLSTAT, V$ROLLNAME
3 where V$ROLLSTAT.USN=V$ROLLNAME.USN 4 /

NAME                   OPTSIZE   SHRINKS AVESHRINK     WRAPS   EXTENDS
-------------------- --------- --------- --------- --------- ---------
SYSTEM                                 0            0                  0
0
RBSEG1                                 0            0                150
0
RBSEG2                                 0            0                127
0
RBSEG3                                 0            0                151
0
RBSEG4                                 0            0                136
0
RBSEG5                                 0            0                150

6 rows selected.

According to Oracle DBA 101, i should re-create my roll back segments. How is that?? Can someone advise me? You know, im just a novice in this field.

Hoping for an easy to follow response. Received on Sun Jan 21 2001 - 23:59:23 CST