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
  7. View Real-time SQL Data from SQL Monitoring

View Real-time SQL Data from SQL Monitoring

  1. On the Performance Hub page, click SQL Monitoring to display the SQL monitoring tab.

  2. In the SQL ID column, click an ID to display detailed information about the specific SQL statement execution.

    This action displays the Performance Hub Real-time SQL Monitoring page.

  3. Scroll down to display the SQL activities.

    Depending on the database selected, the Details section includes Plan Statistics, Parallel, SQL Text, and Activity tabs.

    In the Details section of the page:

    • Click Plan Statistics to view the Tabular Execution Plan and Graphical Explain Plan.

    • Click Parallel to view the Parallel Server and the Instances and Parallel Groups it contains.

    • Click SQL Text to view the text of the active SQL query.

    • Click Activity to view the active sessions of the database that is selected.

      Use the menu on the details page to view either the Active Sessions Resource Type or Plan Line of the selected SQL operation.

  4. Click the Back arrow at the top-left corner of the page to go back to the SQL Monitoring tab.