--查看統計了什么東西
select * from v$statistics_level;

--查看workload_repository的基本設置;
select * from dba_hist_wr_control;

--修改workload_repository的基本設置;
exec dbms_workload_repository.modify_snapshot_settings(
  retention=>21600,
  interval =>30
);

--創建快照
exec sys.dbms_workload_repository.create_snapshot();

--查看快照歷史
select * from dba_hist_snapshop;

--刪除快照歷史
exec dbms_workload_repository.drop_snapshot_range(4650,4720);

--查看會話歷史
select * from v$active_session_history;

--查看AWR報告
$ORACLE_HOME/rdbms/admin/awrrpt.sql
或
$ORACLE_HOME/rdbms/admin/awrrpti.sql


--ADDM部分
--生成ADDM報告
$ORACLE_HOME/rdbms/admin/addmrpt.sql

--查看ADDM在２４小時內生成的報告
select type,count(*) 
  from  dba_advisor_findings
   natural join dba_advisor_tasks
  where created between sysdate-1 and sysdate
  group by type

--查看某一推薦
select message 
  from  dba_advisor_recommendations
   nature join dba_advisor_findings
    using(finding_id,task_id)
  where rank=0

--更改addm設置
 exec dbms_advisor.set_default_task_parameter(
  'ADDM','DBIO_EXPECTED',16000);