sql語句引起的CPU佔用國高

SQL效率問題， SQL code 1.用top看下那個程式佔cpu資源比較多，記下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 * from v$sql where sql_id=''

select s.sid,s.serial#,p.program,p.spid from v$session s,v$process p
where s.paddr=p.addr /*and p.spid='&sid'*/;

/*get_sql_by_sid.sql*/
select sql_text from v$sqltext a where a.hash_value in
(select sql_hash_value from v$session b /*where b.sid='&sid'*/)
order by piece asc;

[@more@]