NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_undo_autotune boolean FALSE
undo_management string AUTO
undo_retention integer 86400
undo_tablespace string UNDOTBS1
SQL>
SQL> select tablespace_name,status,count(*) from dba_rollback_segs group by tablespace_name,status;