SELECT target,COUNT(*) as wait_times,SUM(t.ELAPSED_SECONDS) as wait_seconds FROM V$SESSION_LONGOPS t GROUP BY t.target;
v$session_longops查等待次数和等待时间集中的对象
最新推荐文章于 2021-04-07 19:53:09 发布
SELECT target,COUNT(*) as wait_times,SUM(t.ELAPSED_SECONDS) as wait_seconds FROM V$SESSION_LONGOPS t GROUP BY t.target;