Showing posts with label How to identify the rollback/Undo segments used by a session in oracle database. Show all posts
Showing posts with label How to identify the rollback/Undo segments used by a session in oracle database. Show all posts

Friday, January 13, 2012

How to identify the rollback/Undo segments used by a session in oracle database

select *
from   v$rollname
where usn = (select xidusn
                      from   v$transaction
                      where addr in (select taddr
                                              from   v$session
                                              where sid=&session_id));