Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • get DBID, Instance number, and range of snapshots for AWR report

    Panel
    select * from dba_hist_snapshot;
  • For text report:

    Panel
    select output from table(dbms_workload_repository.awr_report_text(DBID,INSTNUM,SNAPSTART,SNAPSTOP));
  • For HTML report:

    Panel
    select output from table(dbms_workload_repository.awr_report_html(DBID,INSTNUM,SNAPSTART,SNAPSTOP));

(spool to file, if applicable)