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 number of SQL statements that hit the current throttling rule on the current node for the current tenant at the current moment. It is used to observe the impact of the throttling rules set in the current system.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| CON_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the BServer node. |
| CCL_RULE_ID | NUMBER(38) | NO | The ID of the effective throttling rule. |
| FORMAT_SQLID | VARCHAR2(32) | NO | The throttling granularity: |
| CURRENT_CONCURRENCY | NUMBER(38) | NO | The number of SQL statements that are currently being executed and hit the throttling rule. |
| MAX_CONCURRENCY | NUMBER(38) | NO | The maximum concurrency of the throttling rule. |
Sample query
obclient> SELECT * FROM V$OB_SQL_CCL_STATUS;