Managing Real-Time Sessions

Scenarios

You can query session snapshots of your instance while sorting, filtering, and displaying the snapshots as needed. You can also view session statistics by user, source, and database. Sessions can be killed for urgent instance recovery to ensure database availability.

Precautions

Killing a session may cause service disconnection. Your applications should be able to reconnect to the instance.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the target instance name.
5. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
6. Click the Sessions tab. You can perform the following operations on this tab page:
   • Viewing session statistics
     In the session statistics area, you can view the session summary and session statistics by user, source, and database.

     Figure 1 Sessions
     
   • Killing abnormal sessions

     In the session list, select the abnormal session you want to end and click Kill Session to recover the database.

   • Exporting the session list

     To export the session list, click above it.