Basic transaction details for a SID

set linesize 220
SELECT a.sid, a.username, b.xid, b.START_DATE, b.status trans_status
FROM gv$session a, gv$transaction b
WHERE a.saddr = b.ses_addr
and a.sid = ???;

******************************************
keywords:
******************************************
rdbms version:
******************************************