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));

1 comment:

  1. Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!

    sap online training
    software online training
    sap sd online training
    hadoop online training

    ReplyDelete