Note
This view is available starting with V4.3.5 BP3.
Purpose
This view records the number of SQL statements that hit the current throttling rules on the current node for the current tenant at the current moment. 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 active 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;