Note
This view is available starting with OceanBase Database V4.3.5 BP3 for V4.3.X versions.
This view is available starting with 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 | NUMBER(38) | NO | The tenant ID. |
| CCL_RULE_ID | NUMBER(38) | NO | The throttling rule ID. |
| CCL_RULE_NAME | VARCHAR2(128) | NO | The throttling rule name. |
| AFFECT_USER_NAME | VARCHAR2(64) | NO | The user to which the throttling applies. |
| AFFECT_HOST | VARCHAR2(128) | NO | The IP address to which the throttling applies. |
| AFFECT_FOR_ALL_DATABASES | NUMBER(38) | NO | Indicates whether the throttling applies to all databases. |
| AFFECT_FOR_ALL_TABLES | NUMBER(38) | NO | Indicates whether the throttling applies to all tables. |
| AFFECT_DATABASE | VARCHAR2(128) | YES | The database to which the throttling applies. |
| AFFECT_TABLE | VARCHAR2(256) | YES | The table to which the throttling applies. |
| AFFECT_DML | NUMBER(38) | NO | The DML statement type to which the throttling applies. |
| AFFECT_SCOPE | NUMBER(38) | NO | The throttling scope: |
| CCL_KEYWORDS | VARCHAR2(1048576) | NO | The throttling keywords. |
| MAX_CONCURRENCY | NUMBER(38) | NO | The maximum concurrency for throttling. |
Sample query
Query the throttling rules of the current user tenant.
obclient > SELECT * FROM DBA_OB_CCL_RULES;