Using the AWR Hub Explorer

The AWR Hub explorer allows you to explore AWR’s performance statistics via SQL queries that extract data with which intuitive visualization can be created. The queries utilize data objects which in this case are simply the DBA_HIST_* views. These views contain the AWR snapshots stored within the AWR Hub.

Before you begin using AWR Hub Explorer, make sure the following prerequisites are met:
To access the AWR Hub Explorer follow these steps:
  1. Open the navigation menu, click Observability & Management. Under Ops Insights, click AWR Hub. You’ll be taken to the AWR Hub page.
  2. Click on the Launch AWR Hub Explorer button, located above the AWR Sources table.
For a detailed explanation on using and creating queries for the AWR Hub Explorer see: Using AWR Hub Explorer Data Objects.