Note
- For OceanBase Database V4.3.x, this parameter was introduced in OceanBase Database V4.3.2.
- For OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.3.
Description
enable_global_background_resource_isolation specifies whether to enable global resource isolation between foreground and background tasks.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter. In thesystenant, you can also query theinformation_schema.PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter only in the
systenant.
Attributes
| Attribute | Description | |
|---|---|---|
| Type | Boolean | |
| Default value | false | |
| Value range | [true, false]
|
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
|
| Effective upon OBServer node restart | Yes. If the modification involves multiple OBServer nodes, all of them must be restarted. |
Examples
Specify to isolate resources for background and foreground tasks within a tenant.
obclient> ALTER SYSTEM SET enable_global_background_resource_isolation=false;