AWR

AWR reports are the first thing DBAs would generate when a performance issue is reported during an interval. An AWR report shows us the data captured between two snapshots. The AWR report has the workload profile of the database system. The AWR option in SQL Developer gives us three more options, which are as follows:

  • AWR Report Viewer: AWR report can be generated between two snapshots or baselines
    AWR
  • Difference Report Viewer: AWR difference report can be generated between two snapshots or baseline periods.
    AWR
  • SQL Report Viewer: Generates a Workload Repository ...

Get Oracle SQL Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.