Kevin's script to get ash report in html format accept minb prompt 'please input begin time: hh24mi : ' accept mine prompt 'please input end time hh24mi: ' col dbid new_value dbid; col rname new_value rname; set verify off set feed off set head off select dbid,name,'c:\logs\'||name||'_ash_'||&&minb||'_'||&&mine||'.html' rname from v$database; spool &rname SELECT output FROM TABLE(dbms_workload_repository.ASH_REPORT_HTML (&dbid,1,to_date(to_char(sysdate,'DD-MON-YYYY')||':'||'&&minb','dd-mon-yyyy:hh24mi'),to_date(to_char(sysdate,'DD-MON-YYYY')||':'||'&&mine','dd-mon-yyyy:hh24mi'))); spool off @setup undefine minb undefine mine undefine dbid Below is a link from internet. http://yangtingkun.net/?p=552 11.2.0.3更改AWR报告底层TYPE类型 Posted on 2012/02/08 by yangtingkun 在11.2.0.2中读取AWR报告的过程在11.2.0.3中报错。 ...