Note
This view is available starting with OceanBase Database V4.3.5 BP3 for V4.3.x releases.
For V4.4.x releases, this view is available starting with OceanBase Database V4.4.1.
Purpose
This view records the number of SQL statements that are currently hitting the throttling rules on each node for all tenants. It is used to observe the impact of the throttling rules set in the system.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the BServer node. |
| CCL_RULE_ID | bigint(20) | NO | The ID of the effective throttling rule. |
| FORMAT_SQLID | varchar(32) | NO | The throttling granularity: |
| CURRENT_CONCURRENCY | bigint(20) | NO | The number of SQL statements currently hitting the throttling rule. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum concurrency allowed by the throttling rule. |
Sample query
obclient> SELECT * FROM oceanbase.GV$OB_SQL_CCL_STATUS;