Using the AWR Hub Explorer

AWR Hub Explorer enables you to explore AWR 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:

Create the warehouse and configure the AWR Hub, see: Configure the AWR Hub.
Configure the database sources, see: Configure Database Sources.

To access AWR Hub Explorer:

Open the navigation menu, click Observability & Management, and then click Ops Insights.
In the left pane, click Database Insights, and then click AWR Hub.
Click Actions and then select Launch AWR Hub Explorer.

For a detailed explanation on using and creating queries for the AWR Hub Explorer, see Using AWR Hub Explorer Data Objects.

Oracle Cloud Infrastructure Documentation

Using the AWR Hub Explorer