根据PID查询Oracle执行进程的情况



根据PID查找对应正在执行的sql语句

SELECT   sql_text

    FROM   v$sqltext a

  WHERE   a.hash_value = (   SELECT   sql_hash_value

                           FROM   v$session b, v$process c

                          WHERE   b.paddr = c.addr

                            AND   c.spid =  PID )

  ORDER   BY   piece   ASC   ;

根据PID查找正在执行的进程

SELECT   s.username, s.sid, s.serial#

    FROM   v$session s, v$process p

  WHERE   s.paddr = p.addr

     AND   p.spid =  PID