Note
This view is available starting with OceanBase Database V4.3.5 BP3 for V4.3.X versions.
For V4.4.X versions, this view is available starting with OceanBase Database V4.4.1.
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 throttling rule ID. |
| CCL_RULE_NAME | varchar(128) | NO | The throttling rule name. |
| 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 type 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 throttling. |
Sample query
Query the throttling rules of all tenants.
obclient[oceanbase]> SELECT * FROM DBA_OB_CCL_RULES;