SELECT A.PID, A.SPID, B.SID, B.SERIAL#, C.SQL_TEXT
FROM V$PROCESS A, V$SESSION B, V$SQLAREA C
WHERE A.ADDR = B.PADDR
AND B.SQL_ADDRESS = C.ADDRESS
AND A.SPID = 2156;[@more@]