Oracle擷取AWR和ASH

標籤：

 

-- 找到指定的snapselect snap_id, max(sample_time) from sys.wrh$_active_session_history group by snap_idorder by snap_id desc;-- AWRSELECT * FROM TABLE(dbms_workload_repository.awr_report_html(      (select dbid from v$database), 1,       26663,  -- begin snap_id        26664   -- end snap_id       ));-- ASHSELECT * FROM TABLE(dbms_workload_repository.ash_report_html(     (select dbid from v$database), 1,       SYSDATE - 90 / (24 * 60),   -- begin datetime       SYSDATE - 60 / (24 * 60)    -- end     ));-- ADDMselect * from dba_advisor_tasks s order by  s.created desc-- sqlplus設定參數set long 1000000 pagesize 0 longchunksize 1000  select dbms_advisor.get_task_report(‘ADDM:2199108538_1_26664‘) from dual;

Oracle擷取AWR和ASH