rollback segments

[ashley75]

how I do find out which rollback segment being used for the process in the database ???

thanks

[marist89]

select a.name, b.xacts, c.sid, c.serial#, c.username, d.sql_text, e.status
from v$rollname a, v$rollstat b, v$session c, v$sqltext d, v$transaction e
where a.usn=b.usn
and b.usn=e.xidusn
and c.taddr = e.addr
and c.sql_address = d.address
and c.sql_hash_value = d.hash_value
order by a.name, c.sid, d.piece

[ashley75]

Thanks Jeff