Oracle 客户端生成AWR方法

本地生成awr的步骤: 赋权：grant execute on DBMS_WORKLOAD_REPOSITORY to user; a)         sqlplus fmsuser/密码 b)         执行如下sql SELECT   snap_id, snap_level, instance_number,          to_char(begin_interval_time, 'yyyy/mm/dd hh24:mi:ss') begin_interval_time,          to_char(end_interval_time, 'yyyy/mm/dd hh24:mi:ss') end_interval_time,          to_char(flush_elapsed) flush_elapsed,          to_char(startup_time, 'yyyy/mm/dd hh24:mi:ss') startup_time,          error_count FROM     DBA_HIST_SNAPSHOT WHERE    dbid = XXXXXX AND      instance_number = 1 order by 1 c)         根据查询结果获得需要快照id d)         于sqlplus环境下执行 set head off spool c:\snapshot.html   SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML(DBID_NUMBER, 1, SNAP_ID, SNAP_ID) ) ; e)         观看c盘根目录下的snapshot.html