The CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES procedure specifies the type and number of logical resources required for a tenant and calculates the amount of physical resources needed to accommodate these logical resources.
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_LOGIC_RES(args IN VARCHAR);
Parameters
args is a string in the following format:
'ls: 1, tablet: 20000';
'ls: 10';
'tablet: 20000'
| Parameter | Description |
|---|---|
| ls | The number of logical resources of type ls. |
| tablet | The number of logical resources of type tablet. |
Examples
You can calculate the required physical resources as follows:
obclient> CALL DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES("LS: 15, TABLET:40000");
+------------------------+-------------+
| PHYSICAL_RESOURCE_NAME | MIN_VALUE |
+------------------------+-------------+
| MEMSTORE | 0 |
| MEMORY | 4194304000 |
| DATA_DISK | 0 |
| CLOG_DISK | 10737418240 |
| CPU | 0 |
+------------------------+-------------+
5 rows in set (0.003 sec)