Note
This view is available starting with OceanBase Database V4.3.5 BP3 for V4.3.X versions and OceanBase Database V4.4.1 for V4.4.X versions.
Purpose
This view records all throttling rules for the current user tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| CCL_RULE_ID | bigint(20) | NO | The ID of the throttling rule. |
| CCL_RULE_NAME | varchar(128) | NO | The name of the throttling rule. |
| AFFECT_USER_NAME | varchar(128) | NO | The user to which the throttling rule applies. |
| AFFECT_HOST | varchar(128) | NO | The IP address to which the throttling rule applies. |
| AFFECT_FOR_ALL_DATABASES | tinyint(4) | NO | Indicates whether the throttling rule applies to all databases. |
| AFFECT_FOR_ALL_TABLES | tinyint(4) | NO | Indicates whether the throttling rule applies to all tables. |
| AFFECT_DML | bigint(20) | NO | The DML statement to which the throttling rule applies. |
| AFFECT_DATABASE | bigint(20) | YES | The database to which the throttling rule applies. |
| AFFECT_TABLE | bigint(20) | YES | The table to which the throttling rule applies. |
| AFFECT_SCOPE | bigint(10) | NO | The throttling scope. Valid values: |
| CCL_KEYWORDS | varchar(1048576) | NO | The throttling keyword. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum allowed concurrency. |
Sample query
Query the throttling rules of the current user tenant.
obclient[oceanbase]> SELECT * FROM DBA_OB_CCL_RULES;