select ss.sid,se.command,ss.value cpu ,se.machine,se.username,se.program
from v$session se,v$sesstat ss where ss.statistic# in (
select statistic# from v$statname where name='CPU used by this session')
and se.sid=ss.sid and ss.sid > 6 order by ss.value desc;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/50509/viewspace-174270/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/50509/viewspace-174270/