Note
This view is available starting with V4.3.5 BP3.
Purpose
This view records the number of SQL statements that hit the throttling rules on all nodes of the current tenant at the current moment, 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 that are currently being executed and hit the throttling rule. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum concurrency of the throttling rule. |
Sample query
obclient> SELECT * FROM oceanbase.GV$OB_SQL_CCL_STATUS;