如何用sql 语句查询出oracle的cpu使用率

2025-04-29 18:21:15
推荐回答(1个)
回答1:

select * from (select sql_text,sql_id,cpu_time from v$sql order by cpu_time desc) where rownum<=10 order by rownum asc ;
select * from (select sql_text,sql_id,cpu_time from v$sqlarea order by cpu_time desc) where rownum<=10 order by rownum asc ;