Manage the sessions of a tenant

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

Procedure

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

• Method 1:

  Log on to the OceanBase Cloud Platform (OCP) console and go to the Real-time Diagnostics page. Click the Session Management tab. The Tenant Session tab automatically appears.

• Method 2:

  Log on to the OCP console and go to the Overview page of the target tenant. In the left-side navigation pane, click Session Management. The Tenant Session tab automatically appears.

The procedure of Method 1 is described as follows:

1. Log on 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 automatically 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 View SQL in the SQL column. In the dialog box that appears, you can view and copy the SQL details of this session.

   

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.