Postgresql, Autocommit, Oracle.
t=current_timestamp; for i in ( select addr,ses_addr from v$transaction) loop dbms_output.put_line( 'Transaction: ADDR: '||i.addr||' SES_ADDR: '||i.ses_addr ); end loop; rollback; end; / rollback; quit This shows that there can be multiple transactions for the same session. The PADDR is only the