« 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;
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.