rollback segment

[elintrend]

Hi All,

I try to find out have my rollback segment been set OPTIMAL but I forgot where to look from. It's not in dba_rollback_segs. Can anyone give me a quick help?
Thanks.

[bill_lee]

select N.Name, /* rollback segment name */
S.OptSize/1048576 optSize_MB /* rollback segment OPTIMAL size */
from V$ROLLNAME N, V$ROLLSTAT S
where N.USN=S.USN;