Originally posted by pando
SELECT name, rssize FROM v$rollstat a, v$rollname b where a.usn=b.usn

and look which RBS is holding the space
This is what i get

SQL> SELECT name, rssize FROM v$rollstat a, v$rollname b where a.usn=b.usn
2 /

NAME RSSIZE
------------------------------ ----------
SYSTEM 401408
RB0 565248
RB1 565248
CTXROL 237568
RB2 565248
RB3 565248
RB4 565248
RB5 565248
RB6 565248
RB7 565248