查看快照状态
select * from dba_hist_wr_control;
关闭awr
exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 0);
启动awr
exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 60);
查看快照信息：
select * from dba_hist_snapshot
1 个回答
撰写答案
请登录后再发布答案，点击登录
相关问题
热门问题
