SELECT r.name, s.sid, s.serial#, s.username, s.machine, t.status,
t.cr_get, t.phy_io, t.used_ublk, t.noundo,
substr(s.program, 1, 78) "COMMAND", s.USERNAME "DB User",
t.start_time, s.sql_address "Address", s.sql_hash_value "Sql Hash"
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r
WHERE t.addr = s.taddr
AND t.xidusn = r.usn
ORDER BY t.start_time
SELECT sql_text
FROM V$sqltext_with_newlines
WHERE address = (
SELECT prev_sql_addr
FROM V$session
WHERE username = :uname
AND sid = :snum
)
ORDER BY piece
t.cr_get, t.phy_io, t.used_ublk, t.noundo,
substr(s.program, 1, 78) "COMMAND", s.USERNAME "DB User",
t.start_time, s.sql_address "Address", s.sql_hash_value "Sql Hash"
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r
WHERE t.addr = s.taddr
AND t.xidusn = r.usn
ORDER BY t.start_time
SELECT sql_text
FROM V$sqltext_with_newlines
WHERE address = (
SELECT prev_sql_addr
FROM V$session
WHERE username = :uname
AND sid = :snum
)
ORDER BY piece
