oracle awr 生成

生成awr report
SQL>@?/rdbms/admin/awrrpt.sql
html
Enter value for num_days:8
Enter value for begin_snap:9

生成ash report
SQL>@?/rdbms/admin/ashrpt.sql
html
09/01/18 22:30:00
420

不登录服务器用system用户生成

select snap_id,dbid,instance_number,end_interval_time from dba_hist_snapshot where end_interval_time > sysdate -1 and instance_number =1 order by  snap_id;
SQL> set echo off
SQL> set veri off
SQL> set feedback off
SQL> set heading off
SQL> set linesize 1500
SQL> set termout off
SQL> spool D:\awr_19-3.html
SQL> select output from table(dbms_workload_repository.AWR_REPORT_HTML(3030112051,1,24115,24123,0));

select output from table(dbms_workload_repository.AWR_REPORT_HTML(dbid,instance_number,snap_id,snap_id,0));

SQL> spool off