select sql_text,cpu_time,buffer_gets from ( select sql_text,cpu_time,buffer_gets from v$sql order by cpu_time desc) where rownum<5
查询当前系统耗费CPU资源最多的前5个SQL语句
最新推荐文章于 2024-06-24 08:00:00 发布
select sql_text,cpu_time,buffer_gets from ( select sql_text,cpu_time,buffer_gets from v$sql order by cpu_time desc) where rownum<5