程式查詢

ps auxw --sort=%cpu

按CPU檢視哪個程式耗的資源比較多
--------------------------------------------------
輸入程式號，看是誰在執行

select sa.MODULE,sl.OPNAME, to_char(sl.start_time, 'yyyy-mm-dd hh24:mi:ss') start_time,sa.SQL_TEXT, pr.*,'||',se.*
from v$session se ,v$process pr ,v$session_longops sl,v$sqlarea sa
where se.PADDR=pr.ADDR(+)
and se.SID=sl.SID(+)
and sl.sql_hash_value = sa.hash_value(+)

and pr.SPID in (29657)

[@more@]