Session management allows you to view tenant sessions, collect session statistics, detect deadlocks, and analyze row-level locks.
A session is a connection between an application and a database. On the Session Management page in the ApsaraDB for OceanBase console, you can view all active and idle sessions of a database. You can also view the Tenant Sessions, Session Statistics, Deadlock Detection, and Row-level Lock Analysis tabs to obtain more detailed information.
Tenant Sessions: displays the active and idle sessions at the current moment.
Session Statistics: displays the session statistics by user, access source, and database.
Deadlock Detection: displays the deadlocks in the tenants of the current cluster.
Row-level Lock Analysis: displays the row information and the number of sessions involved in the lock.
For more information, see Session management.