Note
- This view is available starting with V4.1.0.
- In the current version, we recommend that you use the DBA_OB_RSRC_DIRECTIVES view to query the resource configuration parameters of a tenant in the Resource Manager.
Purpose
This view displays the IO resource configuration in the Resource Manager.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | The name of the resource plan to which the directive belongs. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group controlled by the directive. |
| COMMENTS | varchar(2000) | YES | The remarks of the resource plan. |
| MIN_IOPS | bigint(20) | NO | The reserved IOPS resources for the resource group when I/O contention occurs. The sum of the MIN_IOPS values of all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that can be used by the resource group. The sum of the MAX_IOPS values of all resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight of IOPS when I/O contention occurs. The sum of the WEIGHT_IOPS values of all resource groups can exceed 100. Under the premise of meeting the MIN_IOPS and MAX_IOPS settings, I/O resources are allocated based on the normalized weight values. The default value is 0. |
Sample query
Query the IO resource configuration in the Resource Manager of the user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RSRC_IO_DIRECTIVES;
The query result is as follows:
+---------+------------------+----------+----------+----------+-------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS |
+---------+------------------+----------+----------+----------+-------------+
| daytime | batch_group | | 40 | 80 | 70 |
+---------+------------------+----------+----------+----------+-------------+
1 row in set