simplest way to generate awr report by hour after benchmark
export awr
1 | @?/rdbms/admin/awrextr.sql |
import awr
1 | @?/rdbms/admin/awrload.sql |
— make sure to set line size appropriately
— set linesize 152
generate awr
1 2 3 4 5 6 7 | set termout off set linesize 80 set pagesize 10000 select 'spool awrrpt_dwhfrn_' || snap_id || '.html' || chr(13)|| 'select output from table(dbms_workload_repository.awr_report_text(' ||dbid|| ',1,' ||snap_id|| ',' || LEAD (snap_id, 1) OVER ( ORDER BY dbid,snap_id ) || ',0));' || chr(13)|| ' spool off ' from dba_hist_snapshot where dbid !=1399642255 and extract( minute from begin_interval_time ) <2 ; |