对视图没有查询权限? 如果有权限,以下能够执行(没有TYPE字段) select * from (select count(*), e.event, sum(e.total_waits) totwaits, sum(e.time_waited) / 100 tottime, max(e.time_waited) / 100 maxtime, (sum(e.time_waited) / sum(e.total_waits)) / 100 avgtime from v$session_event e, v$session s where e.total_waits > 0 and e.event not like '%time%' and e.event not like '%SQL*Net%' and e.event not like '%pipe%' and e.event not like '%ipc%' and e.sid = s.sid -- and e.type = 'USER' group by e.event order by count(*) desc) where rownum < 11;
如果有权限,以下能够执行(没有TYPE字段)
select *
from (select count(*),
e.event,
sum(e.total_waits) totwaits,
sum(e.time_waited) / 100 tottime,
max(e.time_waited) / 100 maxtime,
(sum(e.time_waited) / sum(e.total_waits)) / 100 avgtime
from v$session_event e, v$session s
where e.total_waits > 0
and e.event not like '%time%'
and e.event not like '%SQL*Net%'
and e.event not like '%pipe%'
and e.event not like '%ipc%'
and e.sid = s.sid
-- and e.type = 'USER'
group by e.event
order by count(*) desc)
where rownum < 11;
2、代码中部分字段错误
v$session_event没有total_wait字段,应该为total_waits
v$session_event没有type字段,v$session中有type字段
FOR zlloct 我剛剛檢查我的授權為sysdba 應該是可以的,後來複製你的代碼就可以了 哈哈!!
FOR bw555 謝謝你的糾正 好像真的沒有而在v$SESSION中謝謝!