awr sql report

生成awr报告

229x355 - 109KB - PNG

如何定位那些SQL产生了大量的redo日志

652x262 - 19KB - PNG

2、AWR_SET_REPORT_THRESHOLDS从AWR中的过滤出多少条sql生成在AWR报告里。相比之下前者是基础，从我们已经

decode(sqt.module,null,null,'Module:'|sqt.module),nvl(st.sql_text,to_clob('*SQL Text Not Available*'

标签： it 分类：Oracle DBA Global Cache blocks received:per transaction select round(((SELECT e.

SELECT DECODE(e.TOTAL_SQL,0,0,100*(1-e.SINGLE_USE_SQL/e.TOTAL_SQL)) FROM DBA_HIST_SQL_SUMMARY e

where st.sql_id(+)=sqt.sql_id and st.dbid(+)=dbid order by nvl(sqt.elap,-1)desc,sqt.sql_id)where

标签： it 分类：Oracle DBA Avg global enqueue get time(ms): select decode(v_2,0,'',v_1/v_2)

HEAD><TITLE>AWR SQL Report</TITLE><style type="text/css">body.awr {font:bold 10pt Arial,

e.sql_free_evaluations-nvl(b.sql_free_evaluations,0), e.sql_executions-nvl(b.sql_executions,0), e.