Oracle Cloud Infrastructure Documentation

Viewing Performance Hub

Performance Hub displays SQL statement information for the selected time period, and you can improve the performance of your database applications by monitoring query performance. It enables you to accurately find out the root cause of a slow down in the SQL code, and improve SQL code during development as well as continuously monitor and tune queries running on production systems.

Note

Performance hub is not available in an Always Free DB system.

Using the Console

Use the console to view Performance Hub to monitor and analyze SQL performance and obtain greater visibility into performance issues.

This task requires the following:
Do the following to view Performance Hub:
  1. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.

    The details page opens and displays information about the DB system.

  2. Select Performance Hub at the top of the page to open the Performance Hub page.
You can see average statement latency, top 100 SQL statements, and other details.

Related Topics