Overview
enable_global_background_resource_isolation is used to enable global background and foreground resource isolation.
Privilege requirements
Query parameters
The
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview can be used by thesystenant and all user tenants to query this parameter. Thesystenant can also query this parameter through theinformation_schemaарамЕТРЫview.Modify parameters
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Bool |
| Default Value | false |
| Value range | [true, false]
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | Yes, if the modification involves multiple OBServer nodes, all OBServer nodes need to be restarted. |
Configuration example
Isolate backend and frontend tasks within a tenant.
obclient> ALTER SYSTEM SET enable_global_background_resource_isolation=false;