View session statistics

This topic describes how to view the statistics of tenant sessions.

You can view statistics of tenant sessions from the following entries:

• Entry 1:

  Log on to the OceanBase Cloud Platform (OCP) console and go to the Overview page of the target tenant. In the left-side navigation pane, click Session Management and go to the Session Statistics tab.

• Entry 2:

  Log on to the OCP console and go to the Real-time Diagnostics page. Click Session Management and go to the Session Statistics tab.

Procedure

The following procedure takes Entry 2 as an example.

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 target cluster.

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

5. Click the Session Statistics tab and view the statistics of all sessions of the tenant.

   The session statistics are displayed in fields such as Total Sessions, Active Sessions, and Maximum Session Duration. Statistics about the total number of sessions and the number of active sessions are further displayed by user, IP address, and database.

   Note

   Statistics by IP address are provided only for OceanBase Database V2.2.30 and later.