Note
This view is available starting with OceanBase Database V4.3.5 BP3 for V4.3.X.
This view is available starting with OceanBase Database V4.4.1 for V4.4.X.
Purpose
This view records all the throttling rules of the current user tenant.
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(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 types 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: |
| CCL_KEYWORDS | varchar(1048576) | NO | The throttling keywords. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum number of concurrent sessions allowed. |
Sample query
Query the throttling rules of the current user tenant.
obclient[oceanbase]> SELECT * FROM DBA_OB_CCL_RULES;