Oracle慢SQL

select *
from (
	select 
		rank() over(order by v.cpu_time desc) "rank",v.sql_id,sa.sql_fulltext as SQL_FULLTEXT,--case WHEN "LENGTH"(v.sql_text)=1000 then 1 else 0 end as "len_gt_1000",v.EXECUTIONS AS "执行次数",v.FIRST_LOAD_TIME AS 初次载入时间,cast(v.elapsed_time/1000/v.EXECUTIONS as INTEGER) AS "AVG_消耗时间s",cast(v.cpu_time/1000/v.EXECUTIONS as INTEGER) AS "AVG_CPU时间s",--cast(v.elapsed_time/1000 as INTEGER) AS "消耗时间s",--cast(v.cpu_time/1000 as INTEGER) AS "CPU时间s",CAST(v.disk_reads/v.executions as integer) as "AVG_DISKREADS"
	from v$sql v INNER JOIN v$sqlarea sa on v.sql_id=sa.sql_id
) a
where "rank" <= 20;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!