1、查看CPU占用多的会话sid
select s.sid,s.value "CPU Used" ,n.STATISTIC#,n.NAME
from v$sesstat s,v$statname nwhere 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);