The CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT procedure specifies the primary tenant and the number of units for the standby tenant to calculate the minimum physical resources required for each unit.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT(primary_tenant_id IN INTEGER,
standby_tenant_unit_num IN INTEGER);
Parameters
| Parameter | Description |
|---|---|
| primary_tenant_id | The ID of the primary tenant. |
| standby_tenant_unit_num | The number of units for the standby tenant. |
Examples
You can specify the primary tenant and the number of units for the standby tenant and execute the following statement to calculate the minimum physical resources required for each unit.
obclient> CALL DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT(PRIMARY_TENANT_ID => 1001, STANDBY_TENANT_UNIT_NUM => 2);
+------------------------+-------------+
| PHYSICAL_RESOURCE_NAME | MIN_VALUE |
+------------------------+-------------+
| MEMSTORE | 0 |
| MEMORY | 4194304000 |
| DATA_DISK | 0 |
| CLOG_DISK | 10737418240 |
| CPU | 0 |
+------------------------+-------------+
5 rows in set (0.003 sec)