View row lock analytics

This topic describes how to view row lock analytics.

Prerequisites

• Make sure that you have the following permissions:

  • Resource Permissions : Cluster Read-only or Tenant Read-only permission
  • Menu Permissions : Permission on the Real-time Diagnostics menu of OceanBase Autonomy Service

• You have the permissions to manage tenants.

Procedure

1. Log on to the OceanBase Cloud Platform (OCP) console.

2. In the left-side navigation pane, click OceanBase Autonomy Service .

3. In the Cluster Details section, click the name of the cluster that you want to view.

4. Go to the Session Management tab of the Real-time Diagnostics page.

5. Click the Row-level Lock Analysis tab.

6. On the Row-level Lock Analysis tab, you can perform the following operations:

   • Select the target tenant and view its row lock details, such as the row information and the number of sessions involved with the lock.

   • To release a session that holds a row lock, you can close the session. Before you close the session, make sure that the session and the business SQL queries being executed in the session can be securely terminated.

     Note

     • The **Row-level Lock Analysis** tab displays the real-time information of only row locks that have lasted more than 20 ms and the related sessions. The row lock analysis feature is supported only in OceanBase Database V4.2 and later.
     • The row lock information may be stale. If the ID of the session that holds the row lock is not displayed, the transaction may have been completed.