DROP CONCURRENT_LIMITING_RULE

Purpose

This statement is used to drop a throttling rule.

Limitations and considerations

To execute the DROP CONCURRENT_LIMITING_RULE statement in OceanBase Database in Oracle-compatible mode, you must have the drop any concurrent_limiting_rule privilege.

Syntax

DROP CONCURRENT_LIMITING_RULE [ IF EXISTS ] "ccl_rule_name1" [, "ccl_rule_name2", ...]

ccl_rule_name specifies the name of the throttling rule.

Examples

Execute the following statement to drop the throttling rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule.

obclient> DROP CONCURRENT_LIMITING_RULE "sql1_keywords_ccl_rule","sql2_keywords_ccl_rule";