oracle cpu占用分析

1、查看CPU占用多的会话sid

select s.sid,s.value "CPU Used" ,n.STATISTIC#,n.NAME

from v$sesstat s,v$statname n 
where s.statistic#=n.statistic# and n.name='CPU used by this session' 
and s.value>0 

order by 2 desc; 

2、根据sid查看其当前执行的sql

select b.SQL_TEXT,
a.SID,
a.SERIAL#
from v$session a, v$sqlarea b
where a.SQL_HASH_VALUE = b.HASH_VALUE(+)  and sid in(x1,x2,x3);