enable_sys_unit_standalone

Description

enable_sys_unit_standalone specifies whether to allow the system tenant unit to be deployed on a standalone server.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  Only the sys tenant can modify this parameter. User tenants cannot modify this parameter.

Attributes

Considerations

When this parameter is set to True, the following effects occur:

• When you create or add a resource pool, you must consider the system tenant unit. You cannot deploy the system tenant unit and a user tenant unit on the same server.

• The system automatically migrates other units that are deployed on the same server as the system tenant unit.

• When you offline or delete a server, the system first migrates the system tenant unit, and then migrates other tenant units. Other tenant units cannot be deployed on the same server as the system tenant unit.

• When you perform tenant group balancing, the system excludes the server that hosts the system tenant unit from the available servers for tenant groups. The tenant group units are evenly distributed across the servers except the one that hosts the system tenant unit.

Examples

Set the system tenant unit to be deployed on a standalone server.

obclient> ALTER SYSTEM SET enable_sys_unit_standalone = False;