This topic describes how to view the SQL collection enabling/disabling history.
You can view the SQL collection enabling/disabling history by using 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.
Method 2: Log in to the OCP console. On the Overview page of a tenant, click SQL Diagnostics in the left-side navigation pane.
Applicability
OCP Community Edition does not support OceanBase Autonomy Service. To use this service, go to the relevant page by using Method 2.
Prerequisites
To view the SQL collection enabling/disabling history 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 view the SQL collection enabling/disabling history 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 SQL Diagnostics menu of Tenants
Procedure
The procedure of Method 1 is described as follows:
In the left-side navigation pane, click OceanBase Autonomy Service. On the Cluster Details page, click the name of the target cluster to go to its Real-time Diagnostics page.
By default, the SQL Diagnostics tab appears.
Click View SQL Collection History.
In the SQL Collection History panel on the right, view the time and actions of SQL collection enabling/disabling operations.
You can sort the operations by time.
You can sort the operations by action (enable or disable).