The CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT stored procedure calculates the amount of physical resources required for each of the specified units in the standby tenant of the specified primary tenant.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
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 in the standby tenant. |
Examples
Run the following command to calculate the amount of physical resources required for each of the specified units in the standby tenant of the specified primary tenant:
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)