SELECT s.sid,
s.serial#,
s.event,
a.sql_text,
a.sql_fulltext,
s.username,
s.status,
s.machine,
s.terminal,
s.program,
a.executions,
s.sql_id,
p.spid,
a.direct_writes
FROM (SELECT * FROM v
s
e
s
s
i
o
n
W
H
E
R
E
s
t
a
t
u
s
=
′
A
C
T
I
V
E
′
)
s
L
E
F
T
J
O
I
N
v
session WHERE status = 'ACTIVE') s LEFT JOIN v
sessionWHEREstatus=′ACTIVE′)sLEFTJOINvsqlarea a
ON s.sql_id = a.sql_id
INNER JOIN v$process p
ON s.paddr = p.addr