Archive

Archive for the ‘tuning’ Category

viewing addm reports

September 12, 2010 Leave a comment
SQL> set long 1000000
SQL> set pagesize 50000
SQL> column get_clob format a80
SQL>select dbms_advisor.get_task_report(task_name) as ADDM_report
    from  dba_advisor_tasks
    where task_id = (
      select max(t.task_id)
      from dba_advisor_tasks t, dba_advisor_log l
      where t.task_id = l.task_id
        and t.advisor_name = 'ADDM'
        and l.status = 'COMPLETED');
Categories: tuning