Real-Time Sessions
Scenarios
You can view execution time and status of SQL statements to identify and process abnormal processes so that your databases can run normally.
Procedure
- On the top menu bar, choose CloudDBA > Real-Time Sessions.
- On the displayed page, view the running sessions, session execution duration, session list, and slow sessions.
- In the upper left corner, the chart shows the number of global sessions, which keeps the same as the search criteria change.
- In the upper right corner, the graph shows the query results based on your search criteria.
- Killing sessions
Select abnormal sessions and click Kill to kill them so that the database can recover.
- Query specified sessions by filters.
Search for sessions by user, host, or database. The two search boxes are associated.
- Set slow SQL threshold.
Set a slow session threshold and click the refreshing button to filter the slow sessions that exceed this threshold.
Parent topic: Cloud DBA
- Scenarios
- Procedure