通过查询语句生成AWR报告

1.获取实例的number：
select instance_number from v$instance;
2.获取数据库的DBID
select dbid from v$database;    3884937456
3.获取对应时间的SNAP_ID
select *
  from (select a.instance_number,
               a.snap_id,
               b.begin_interval_time + 0 begin_time,
               b.end_interval_time + 0 end_time,
               round(value - lag(value, 1, '0')
                     over(order by a.instance_number, a.snap_id)) "db time"
          from (select b.snap_id,
                       instance_number,
                       sum(value) / 1000000 / 60 value
                  from dba_hist_sys_time_model b
                 where b.dbid = (select dbid from v$database)
                   and upper(b.stat_name) in upper(('db time'))
                 group by b.snap_id, instance_number) a,
               dba_hist_snapshot b
         where a.snap_id = b.snap_id
           and b.dbid = (select dbid from v$database)
           and b.instance_number = a.instance_number)
 where to_char(begin_time, 'yyyy-mm-dd') = to_char(sysdate, 'yyyy-mm-dd')
   and instance_number = &inst_id
 order by begin_time, instance_number;
4.生成AWR
 select * from 
 table(dbms_workload_repository.awr_report_html(&dbid ,&inst_id,&start_snap_id,&end_snap_id))