List of active transaction per users

If I have a lock problem (for example a select for update not committed), I can start with the list of active transactions per users:

select s.sid
from gv$transaction t
inner join gv$session s on t.addr = s.taddr;


In a RAC-enabled environment, you have to use the gv$ views.
If you use the v$view in your script, it will only show the information the instance that you are currently logged into.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.