Note
This view is available starting with V4.3.5 BP3.
Purpose
This view records all the throttling rules of the current user tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| CCL_RULE_ID | NUMBER(38) | NO | The ID of the throttling rule. |
| CCL_RULE_NAME | VARCHAR2(128) | NO | The name of the throttling rule. |
| 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 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 of the throttling. |
Sample query
Query the throttling rules of the current user tenant.
obclient > SELECT * FROM DBA_OB_CCL_RULES;