********将AWR报告分析***************
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
——————————————————
********手工生成AWR报告*************
sql>BEGIN
DBMS_WORKLOAD_REPOSITORY.create_snapshot();
END;
/
————————————————————
********查询已经存在的报告**********
select distinct snap_id,dbid from wrh$_active_session_history order by 1;
————————————————————————————————————
********删除指定snap_id 与dbid的报告****
exec DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE(low_snap_id => 26, high_snap_id => 50, dbid => dbid);
——————————————————————————————————————————————————————