Oracle__进程

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 b.spid='$PID'
And b.addr = a.paddr
And a.sql_address = c.address(+) 
Order By c.piece;

[size=medium]
'$PID'，使用PS查看进程ID

Oracle 10056、10053、10046

[/size]