On the Outlines page, you can view outlines of an OceanBase Database tenant, including outlines for throttling, execution plan binding, and index binding.
Prerequisites
For a tenant in MySQL mode, the password box of the OceanBase Cloud Platform (OCP) user must contain the password of the tenant.
For a tenant in Oracle mode, the password box of the OCP user must contain the password of the SYS tenant in the cluster.
Note
To bind indexes and configure throttling, the logged-on tenant in the OCP console must have the tenant update permission.
Features
The outline feature relies on the hint and plan cache features of OceanBase Database. The hint feature determines the selection of the physical plan generation path by specifying the index and the connection method. The plan cache caches physical plans for SQL statements. When the same SQL statement is executed again in the same environment, the system reads its execution plan from the plan cache. It does not have to go through the parser, resolver, rewriter, and optimizer modules again. This speeds up the execution of SQL statements. The outline feature uses hints to specify how to fix plans by modifying the physical execution plan in the plan cache.
Procedure
In the left-side navigation pane, click Tenants and click a tenant in the Tenants list to go to the Overview page of the tenant.
In the left-side navigation pane, click SQL Diagnosis . The SQL Diagnosis page appears.
Click View Outlines in the upper-right corner.
The Outlines page that displays valid outlines automatically appears. You can perform the following operations on this page:
Click Disable Throttling or Unbind in the Actions column to disable a valid outline.
Click the value in the SQL ID/Text column to go to the details page of the SQL statement. For more information about the operations that you can perform on the details page, see View SQL statement details.
Click the All tab to view all the outlines of the tenant.
Click Export Valid Outlines in the upper-right corner to export all columns on the page other than the Actions column to an Excel file.