Manage the sessions of a tenant

This topic describes how to manage the sessions of a tenant.

You can access the session management page by using one of the following methods:

• Method 1: Log in to the OceanBase Cloud Platform (OCP) console. In the left-side navigation pane, click OceanBase Autonomy Service . On the page that appears, find the target cluster and click its name to go to the Real-time Diagnostics page. Then, click the Session Management tab.

• Method 2: Log in to the OCP console and go to the Overview page of the target tenant. In the left-side navigation pane, click Session Management to go to the Tenant Session tab.

Prerequisites

• To manage the sessions of a tenant by using Method 1, 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

• To manage the sessions of a tenant by using Method 2, make sure that you have the following permissions:

  • Resource Permissions : Cluster Read-only or Tenant Read-only permission
  • Menu Permissions : Permission on the Session Management menu of Tenants

Procedure

The procedure of Method 1 is described as follows:

1. Log in to the 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. The Tenant Session tab appears.

5. View all sessions.

   The Tenant Session tab displays information about all sessions of the current tenant in the following columns: Session ID , SQL, SQL ID, User , Source , Database Name , Command , Execution Time (s) , Status , OBServer, and OBProxy. You can search for a session by its ID.

6. View SQL information.

   For a session in the ACTIVE state, click the SQL text in the SQL column. In the dialog box that appears, you can view the SQL details of this session. You can copy the SQL text.

   

7. Search for sessions.

   You can perform a search in the User , Source , and Database Name columns. You can click the search icon next to the column name to open the search box.

   

8. View active sessions.

   You can select View Active Sessions Only in the upper-right corner of the session list to view only sessions in the ACTIVE state.

   

9. Close a session.

   Click Close Session in the Actions column of a session to close it.

10. Exit the session query.

    Click the More icon in the Actions column and select Close Current Query to exit the query.

11. Configure end-to-end tracing.

    Click the More icon in the Actions column and select Full link tracking configuration . For more information, see Configure full link tracking for a tenant.

    Note

    • This option is available only when you access the session management page by using Method 2.
    • You can configure end-to-end tracing at the session level only in OceanBase Database V4.2.1 or later.