« Oracle: sql types | Home | Oracle: list of the system events »

Oracle: list of the running transactions


SELECT a.sid, a.status, a.username, b.xidusn, b.used_urec, b.used_ublk, b.START_TIME
FROM v$session a, v$transaction b
WHERE a.saddr = b.ses_addr
order by START_TIME desc;

Topics: Oracle, transaction | Submitter: checkthis

Comments

You must be logged in to post a comment.