SELECT a.username, a.machine, a.program, a.sid, a.serial#, a.status, c.piece, c.sql_text FROM v$session a, v$process b, v$sqltext c WHERE a.sid=960 AND a.serial#=40850 AND b.addr=a.paddr AND a.sql_address=c.address(+) ORDER BY c.piece 把该语句中的sid和serial#置换一下就可以了。
a.machine,
a.program,
a.sid,
a.serial#,
a.status,
c.piece,
c.sql_text
FROM v$session a,
v$process b,
v$sqltext c
WHERE a.sid=960
AND a.serial#=40850
AND b.addr=a.paddr
AND a.sql_address=c.address(+)
ORDER BY c.piece
把该语句中的sid和serial#置换一下就可以了。