1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Using Automatic Workload Repository Warehouse for Generating Performance Reports
  4. Using Performance Pages with the AWR Warehouse

Using Performance Pages with the AWR Warehouse

You can view historical data, charts, and reports from a configured AWR Warehouse, by switching the View Data mode to AWR Warehouse on the respective performance pages for a source database.

Performance Home Page

Use the Performance Home page with the AWR Warehouse as follows:

  1. If you are already in the AWR Warehouse, skip to 5.
  2. From the Targets drop-down menu, select Databases.
  3. Select a database on the Enterprise Manager dashboard.
  4. From the Performance drop-down menu, select AWR and then AWR Warehouse.
  5. From AWR Warehouse dashboard, highlight a database.

  6. Click the Performance Home button on the AWR toolbar.

    The Performance Home page displays in Historical - AWR Warehouse mode.

    Note:

    You do not have to log in to the source database to view this page.

    The AWR Warehouse selection is available only for databases that have been added as source databases and only to users who have been granted access.

See Also:

"Monitoring User Activity" for more information about the Performance Home page.

ASH Analytics Page

Use the ASH Analytics page with the AWR Warehouse as follows:

  1. If you are already in the AWR Warehouse, skip to 5.
  2. From the Targets drop-down menu, select Databases.
  3. Select a database on the Enterprise Manager dashboard.
  4. From the Performance drop-down menu, select AWR and then AWR Warehouse.
  5. From AWR Warehouse dashboard, highlight a database.

  6. Click the ASH Analytics button on the toolbar.

    The ASH Analytics page displays in Historical - AWR Warehouse mode.

    Note:

    You do not have to log in to the source database to view this page.

See Also:

"Determining the Cause of Spikes in Database Activity" for more information about ASH Analytics.

AWR Report Page

Use the AWR Report page with the AWR Warehouse as follows:

  1. If you are already in the AWR Warehouse, skip to 5.
  2. From the Targets drop-down menu, select Databases.
  3. Select a database on the Enterprise Manager dashboard.
  4. From the Performance drop-down menu, select AWR and then AWR Warehouse.
  5. From AWR Warehouse dashboard, highlight a database.

  6. Click the AWR Report button on the toolbar.

    The AWR Report page displays in Historical - AWR Warehouse mode. Note that you do not have to log in to the source database to view this page.

  7. Click Generate Report.

See Also:

" Resolving Performance Degradation Over Time " for more information about AWR Report.

Compare Period ADDM Page

Use the Compare Period ADDM page with the AWR Warehouse as follows:

  1. If you are already in the AWR Warehouse, skip to 5.
  2. From the Targets drop-down menu, select Databases.
  3. Select a database on the Enterprise Manager dashboard.
  4. From the Performance drop-down menu, select AWR and then AWR Warehouse.
  5. From AWR Warehouse dashboard, highlight a database.

  6. Select Compare Period ADDM from the Compare Period drop-down menu.

    The Compare Period ADDM page displays in Historical - AWR Warehouse mode. Note that you do not have to log in to the source database to view this page.

  7. Complete Steps 1 and 2. Note that database selection in Step 2 lists all databases with AWR data in the warehouse to which you have access.

  8. Click Run to run the comparison.

See Also:

"Comparing Current System Performance to a Baseline Period" for more information about Compare Period ADDM.

Compare Periods Report

Use the Compare Periods Report page with the AWR Warehouse as follows:

  1. If you are already in the AWR Warehouse, skip to 5.
  2. From the Targets drop-down menu, select Databases.
  3. Select a database on the Enterprise Manager dashboard.
  4. From the Performance drop-down menu, select AWR and then AWR Warehouse.
  5. From AWR Warehouse dashboard, highlight a database.

  6. Select Compare Periods Report from the Compare Period drop-down menu.

    The Compare Periods Report page displays in Historical - AWR Warehouse mode. Note that you do not have to log in to the source database to view this page.

  7. Complete First and Second Periods.

    Note:

    The selections for the two periods are derived from data in the warehouse. For the second period, you can select any database in the warehouse to which you have access.

  8. Click Generate Report.

See Also:

"Running the AWR Compare Periods Reports" for more information about Compare Periods Report.