Oracle_历程

Oracle__进程

Select a.username, a.machine, a.program, a.sid, a.serial#, a.status,c.piece, c.sql_textFrom v$session a, v$process b, v$sqltext cWhere b.spid='$PID'And b.addr = a.paddrAnd a.sql_address = c.address(+) Order By c.piece;