col username format a15
select distinct a.sid, d.username, a.value "total CPU",
b.value "Parse CPU",
c.value "ecursive CPU",
a.value - b.value - c.value "other CPU"
from v$sesstat a, v$sesstat b, v$sesstat c, v$session d
where a.statistic# = 12
and b.statistic# = 150
and c.statistic# = 8
and a.sid=d.sid;
select distinct a.sid, d.username, a.value "total CPU",
b.value "Parse CPU",
c.value "ecursive CPU",
a.value - b.value - c.value "other CPU"
from v$sesstat a, v$sesstat b, v$sesstat c, v$session d
where a.statistic# = 12
and b.statistic# = 150
and c.statistic# = 8
and a.sid=d.sid;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11083/viewspace-151818/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
TBS Space
请登录后发表评论
登录
全部评论
