oracle 實時查詢最耗CPU資源的SQL語句

?

1. 先通過top命令查看產用資源較多的spid號

?

2.查詢當前耗時的會話ID，用戶名，sqlID等：
select sid,serial#,machine,username,program,sql_hash_value,sql_id,
?????? to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') as login_time from v$session
where paddr in (select addr from v$process where spid in ('5648612','256523'));

3. 如果上一步sql_id或者 hash_value不為空，則可用v$sqlarea查出當前正在使用的sql
select sql_text
??from v$sqltext_with_newlines
??where hash_value = &hash_value
order by piece;

select * from v$sql where sql_id=''

?

?

?

---CSDN 網友提供的----

?

SELECT 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

?

?

?

------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
網上資源： http://tianlesoftware.download.csdn.net
相關視頻：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(滿); DBA2 群：62697977