V$ROLLNAME

V$ROLLNAME lists the names of all online rollback segments. It can only be accessed when the database is open.

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