查看每个SESSION的CPU利用情况:select ss.sid,ss.VALUE CPU,se.*,sa.* from v$sesstat ss,v$session se,v$sqlarea sa where ss.STATISTIC# in (select STATISTIC# from v$statname where name='CPU used by this session') and ss.SID=se.SID and se.SQL_ID=sa.SQL_ID and ss.SID>6 order by cpu desc
from v$sesstat ss,v$session se,v$sqlarea sa
where ss.STATISTIC# in
(select STATISTIC# from v$statname where name='CPU used by this session')
and ss.SID=se.SID and se.SQL_ID=sa.SQL_ID
and ss.SID>6
order by cpu desc
但一个regexp_substr一次只能取一个,可以定义一个函数来处理。