检查最好cpu的sql
select *
from (select v.sql_id,
v.child_number,
v.sql_fulltext,
v.elapsed_time,
v.cpu_time,
v.disk_reads,
rank() over(order by v.elapsed_time desc) elapsed_rank
from v$sql v) a
where elapsed_rank <= 10
ORDER BY cpu_time desc;
根据执行计划 查看消耗cpu的关键 (可能是没有建联合索引)
EXPLAIN PLAN FOR select position from (select nvl(position,0) position from ZECoursewareScheduleDetail where username=:1 and fid=:2 and kid=:3 order by ADDTIME desc ) where rownum=1 ;
select * from table(DBMS_XPLAN.DISPLAY);