Note
This parameter is available starting with OceanBase Database V1.4.
Description
system_memory specifies the memory capacity reserved for the tenant whose ID is 500.
Notice
The memory reserved for the system cannot be used by regular tenants.
Privilege requirements
Query the parameter:
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Capacity |
| Default value | 0M, which indicates that the system automatically adjusts the memory usage strategy based on the current memory situation. |
| Value range | [0M, +∞) |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The parameter takes effect immediately after it is set. |
Examples
Set the memory capacity reserved for the tenant whose ID is 500 to 0M.
obclient> ALTER SYSTEM SET system_memory = '0M';