Oracle Cloud Infrastructure Documentation

Using AWR Hub Explorer Data Objects

From the AWR Hub Explorer page, you can explore AWR performance data for monitored resources by writing SQL queries, running the queries, and visualizing the returned data.

Write a Query

In the query editor, you can write free-text queries and join different views 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 DBA_HIST_REPORTS in AWR Hub 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 Hub 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 AWR Hub saved search.

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.