1. Database Performance Tuning Guide
  2. Diagnosing and Tuning Database Performance
  3. Monitoring Databases with Performance Hub
  4. Using Performance Hub to Analyze Database Performance
  5. View
  6. Real-time SQL Activity

Real-time SQL Activity

To view Real-time SQL Activity:

  1. Open the Performance Hub page from the database details page, if not already open.

    Note:

    For more information about how to navigate to the Performance Hub page, see:

  2. Use Quick Select, Time Range, Time Zone, and time slider to set the time period of the SQL activity that you want to monitor.

You can view and monitor real-time SQL activity for databases in Oracle Cloud Infrastructure using the ASH Analytics tab or the SQL Monitoring tab.