Top Activity Lite Data
-
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:
-
Click the Top Activity Lite button on the top-right corner to access the Top Activity Lite mode of Performance Hub.Note
The Time Range is fixed to the last hour.
-
Select Auto Refresh and set the time interval to 15 Seconds. This option updates data in the current tab at the set interval.
Similarly, you can select the refresh rate as 30 Seconds or 1 Minute, or turn it off completely.
-
In the ASH Analytics tab, move the time slider in the Average Active Sessions chart to a specific position of your choice.
The tables at the bottom of the page refreshes and displays the activities of your database for the selected time.
-
In the activity tables, click an ID in the SQL ID column to view details for that particular SQL.
Click Back on the top-left corner to go back to the Top Activity Lite page.
-
Click a session in the User Session column to view details for that session.
Click Back on the top-left corner to go back to the Top Activity Lite page.
-
Go to the SQL Monitoring tab to view information about SQL executions.