Use Database Actions to Monitor Active Session History Analytics and SQL Statements

In Database Actions the Performance Hub card provides information about Active Session History (ASH) analytics and current and past monitored SQL statements.

Perform the following prerequisite step as necessary:

• Access Database Actions as the ADMIN user. See Access Database Actions a ADMIN for more information.

The Performance Hub Page

The Performance Hub page shows performance data for a time period you specify.

To navigate to the Performance Hub page, do either of the following:

• In the Launchpad page, select the Monitoring tab and click Performance Hub.

• Click Selector to display the navigation menu. Under Monitoring, select Performance Hub.

  Note: The Performance Hub page is available in the following user interface languages: French, Japanese, Korean, Traditional Chinese, and Simplified Chinese. If you change the language to German, Spanish, Italian, or Portuguese in Preferences, the Performance Hub page reverts to English.

The Performance Hub page consists of these parts:

• Time Range Area: Use the controls in time range area at the top of the page to specify the time period for which you want to view performance data.

• ASH Analytics Tab: Use this tab to explore ASH (Active Session History) information across a variety of different dimensions for the specified time period.

• SQL Monitoring Tab: Use this tab to view the top 100 SQL statement executions by different dimensions for the specified time period, and to view details of SQL statement executions you select.

See Performance Hub in the Database service documentation for more information.