根据PID查找对应正在执行的sql语句SELECT sql_textFROM v$sqltextaWHERE a.hash_value= ( SELECT sql_hash_valueFROM v$sessionb, v$process cWHERE b.paddr= c.addrAND c.spid= PID)ORDER BY piece ASC ;
根据PID查找正在执行的进程SELECT s.username,s.sid, s.serial#FROM v$sessions, v$process pWHERE s.paddr= p.addroracle账号AND p.spid= PID