Note
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.Modify the parameter
You can modify the parameter only in the
systenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | false |
| Value range | true: Resources for background and foreground tasks are isolated at the global level.false: Resources for background and foreground tasks are isolated within a tenant. |
| 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;