Oracle Cloud Infrastructure Documentation

Using AWR Data Explorer Data Objects

From AWR Data Explorer (previously AWR Hub Explorer), select the required compartment and warehouse parameters to scope queries to the intended warehouse.

AWR Data Explorer is available only for Bring Your Own Warehouse data. For information about the AWR_PDB_* Views, see Data Object Reference.

Select a Warehouse

  1. Select the compartment containing the warehouse. Select Include child compartments if you want warehouses in its subcompartments to be listed.
  2. In the Warehouse selector, select the Bring Your Own Warehouse you want to query. Only active Bring Your Own Warehouses in the selected compartment scope are listed.

The compartment selection scopes the available warehouse choices. The selected warehouse determines the available views, columns, and query results. Queries do not combine data across warehouses. Before running a query, confirm that the intended warehouse is selected.

Write a Query

In the query editor, you can write free-text queries and join available views within the selected warehouse into a single query.

To write and run a query:

  1. Click Clear to remove the current query.
  2. Write a new free-text query.
  3. Click Run to execute the new query.
  4. Use the Visualization section to select how to display the query results. You can display results as a table or select another available chart type.

Use Views, Columns, and Sample Queries

Predefined views, columns, and sample queries are available for various AWR_PDB_REPORTS in AWR Data Explorer and can be used as a base for your personalized queries. To view this information, expand View & columns and sample queries above the SQL editor. Use Views and columns to review available views and columns, including their type and description. You can expand a view to see the columns associated with it. Copy a view or column name and paste it into your query as needed.

Use the Search field to search for specific view names or column names.

Click on any Sample query to view query examples. Click Copy to use a sample query as the basis for your own query, and then continue editing it in the SQL editor.

Additional Operations

The AWR Data Explorer offers the following additional operations:

Use the Time range selector to set the time period for your query. Available options include Last day, Last 7 days, and Last 30 days. The bind parameters :opsi_start_time and :opsi_end_time are derived from the selected time range. Use these parameters in your query so the selected time range affects the returned data set.

Click New to reset to the default query.

Click Open to load an existing saved search. A saved search restores its saved warehouse selection. Confirm that the intended warehouse is selected before running or modifying the query.

Saved searches created for the legacy AWR Hub cannot be used directly with a Bring Your Own Warehouse. Create and save a new search for the intended warehouse.

Click Save to save the current query and visualization. Select the compartment, enter the name and description of the search, and then click Save.
Note

When you update a query, you will need to click Run to execute the query before saving your changes.

Click Save as to create a new saved search of the current query and visualization.

Click Export to CSV to export the query results to a CSV file.

Click Edit to update the title and description of the current saved search.

Click Delete to delete a saved search.