V$ROLLNAME

This view lists the names of all online rollback segments. It can only be accessed when the database is open.

Column Datatype Description
USN NUMBER Rollback (undo) segment number
NAME VARCHAR2(30) Rollback segment name