根据进程号(PID)查询相关的SQL语句

摘自【深入解析Oracle----作者：盖国强】

 

 

----修改后

select /*+ ORDERED */ sql_text from v$sqltext a
 where (a.hash_value,a.address) in (
  select decode(sql_hash_value,0,prev_hash_value,sql_hash_value),
         decode(sql_hash_value,0,prev_sql_addr,sql_address)
  from v$session b
    where b.paddr = (select addr from v$process c where c.spid = '&pid'))
      ORDER BY  a.HASH_VALUE ASC,a.piece ASC; 

 

 

 

-------原文如下：

select /*+ ORDERED */ sql_text from v$sqltext a
 where (a.hash_value,a.address) in (
  select decode(sql_hash_value,0,prev_hash_value,sql_hash_value),
         decode(sql_hash_value,0,prev_sql_addr,sql_address)
  from v$session b
    where b.paddr = (select addr from v$process c where c.spid = '&pid'))
      ORDER BY piece ASC;