Note
- This view is available starting with V4.1.0.
- For the current version, we recommend that you use the DBA_OB_RSRC_DIRECTIVES view to view the resource configuration parameters of a tenant in the Resource Manager.
Purpose
This view displays the I/O 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 specified for all resource groups must not exceed 100. Default value: 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 specified for all resource groups can exceed 100. Default value: 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight of IOPS when I/O contention occurs. The sum of the WEIGHT_IOPS values specified for all resource groups can exceed 100. I/O resources are allocated based on the normalized weight values, provided that the MIN_IOPS and MAX_IOPS settings are met. Default value: 0. |
Sample query
Query the I/O resource configuration in the Resource Manager of the sys 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
References
To view the resource configuration parameters of a tenant in the Resource Manager, see DBA_OB_RSRC_DIRECTIVES.