Note
This view is available starting with V4.3.5 BP3.
Purpose
This view records the throttling rules of all tenants.
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(64) | 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 | varchar(128) | YES | The database to which the throttling rule applies. |
| AFFECT_TABLE | varchar(256) | YES | The table to which the throttling rule applies. |
| AFFECT_SCOPE | bigint(20) | NO | The throttling scope: |
| CCL_KEYWORDS | varchar(1048576) | NO | The throttling keywords. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum concurrency of the throttling rule. |
Sample query
Query the throttling rules of all tenants.
obclient[oceanbase]> SELECT * FROM DBA_OB_CCL_RULES;