select ses.osuser, ses.sid, ses.serial#, --trx.addr trx_addr, --ses.saddr, trx.ses_addr, --This mm/dd/yy is probably the worst possible formats... to_char(to_date(trx.start_time, 'mm/dd/yy hh24:mi:ss'), 'dd.mm.yyyy hh24:mi:ss') start_time, trx.used_ublk, trx.used_urec from v$session ses join --v$transaction trx on ses.taddr = trx.addr v$transaction trx on ses.saddr = trx.ses_addr;