Note
This parameter is introduced since OceanBase Database V1.4.
Description
system_memory specifies the size of memory reserved by the system for the tenant with the ID 500.
Notice
Reserved system memory cannot be allocated to user tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | varchar |
| Default value | 0M, which indicates that the system automatically adjusts the memory usage strategy based on the current memory usage. |
| Value range | [0M, +∞) |
| Modifiable | Yes. It can be modified using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No |
Examples
obclient> ALTER SYSTEM SET system_memory='30G';