v$rollname
The names of online rollback segments. This view's usn field can be joined with v$rollstat's usn field and with v$transaction's xidusn field.
Name Null? Type ----------------------------------------- -------- ---------------------------- USN NUMBER NAME NOT NULL VARCHAR2(30)