The CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT stored procedure calculates the minimum physical resources required on a specific node in the specified 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_UNIT(tenant_id IN INTEGER,
server IN VARCHAR);
Parameters
Parameter |
Description |
|---|---|
| tenant_id | The ID of the tenant. |
| server | The IP address and port number of the OBServer node. |
Examples
Execute the following statement to calculate the minimum physical resources required on a specific node in the specified tenant:
obclient> CALL DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT(TENANT_ID => 1001, SERVER => "1.1.1.1:12104");
+------------------------+-------------+
| PHYSICAL_RESOURCE_NAME | MIN_VALUE |
+------------------------+-------------+
| MEMSTORE | 0 |
| MEMORY | 4194304000 |
| DATA_DISK | 0 |
| CLOG_DISK | 10737418240 |
| CPU | 0 |
+------------------------+-------------+
5 rows in set (0.003 sec)