help: v$rollstat, status = full

From: charlie.peltier <here-antispam)_at_verizon.net>
Date: Mon, 10 Jun 2002 01:51:47 GMT
Message-ID: <TCTM8.13377$fM.5315@nwrddc01.gnilink.net>

What does that suppose to mean?

I checked dba_rollback_segs
there is plenty space in the tablespace for the rollback segment to grow. And the max_extents is way up. I am very confused here. Could someone help me out?

Thanks

SQL> ed
Wrote file afiedt.buf

1 select max_extents from dba_rollback_segs 2* where segment_name = 'TRBS01'
SQL> / MAX_EXTENTS

32765

1 row selected.

SQL> select status, name,extents from
2 v$rollstat a, v$rollname b
3 where a.usn=b.usn;

STATUS          NAME                              EXTENTS


--------------- ------------------------------ ----------

FULL            TRBS01                                 12

17 rows selected.

It is only 12 extents, the max is 32765. Why?

Thanks Received on Sun Jun 09 2002 - 20:51:47 CDT