Oracle 常用指令 & SQL - AWR 篇 (AWR section)

AWR 相關指令

-- Create AWR Report using awrrpt.sql (製作AWR報表)

SQL> @?/rdbms/admin/awrrpt.sql

-- Default retention 8 days (調整AWR記錄時間)
-- Modify interval 60min & retention 35 days

exec dbms_workload_repository.modify_snapshot_settings(interval => 60, retention => 50400);
exec dbms_workload_repository.modify_snapshot_settings(interval => 60, retention => 50400, did => 1234567890);

-- Create snapshot manually (手動建立snapshot時間點)

exec dbms_workload_repository.create_snaphost;