作者:CH_Double_C | 来源:互联网 | 2023-09-25 18:01
-----sqlplus中执行(AWR时间段)@?rdbmsadminawrrpt.sql-----手工生成快照execdbms_workload_repository.create_
-----sqlplus中执行(AWR时间段 )
@?/rdbms/admin/awrrpt.sql
-----手工生成快照
exec dbms_workload_repository.create_snapshot();--语句三次执行,归入快照
--查询快照
select * from dba_hist_snapshot order by begin_interval_time desc;
---2hud6nnbgr258具体SQL语句
@?/rdbms/admin/awrsqrpt.sql
等同
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
--删除历史快照
begin
dbms_workload_repository.drop_snapshot_range(5777, 5777, 1446169172);
end;