Hi


1 select n.name, s.optsize
2 from v$rollname n, v$rollstat s
3 where n.usn = s.usn
4* order by n.name
SQL> /

NAME OPTSIZE
------------------------------ ---------
R01
R02
R03
R04
R05
R06
RBIG
SYSTEM

This is what I get and I want to give an optimal size to these segments . Please let me know how do I give that

Regards