查看Oracle查询语句的源代码

==oracle 查看cpu占用情况 以及具体sql语句情况==
1、以下语句可以查出具体占用cpu的情况的spid，占用大小参照value的值
select a.sid,spid,status,substr(a.program,1,40) prog,a.terminal,osuser,value/60/100 value 
from v$session a,v$process b,v$sesstat c 
where c.statistic#=12 and c.sid=a.sid and a.paddr=b.addr order by value desc;

2、以下语句查询出具体sql占用cpu情况
SELECT sql_text piece
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 = '5744' )) 
ORDER BY piece ASC
其中的spid5744可以在第一条语句中获得