The CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT stored procedure calculates the amount of physical resources required for each of the specified units for a standby tenant to be created for the specified primary tenant.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the 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
Execute the following statement to calculate the amount of physical resources required for each of the specified units for a standby tenant to be created for 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)