REALIGN_CONTROL_NODES
Chooses control nodes (spread hosts) from all cluster nodes and assigns the rest of the nodes in the cluster to a control node. Calling this function respects existing fault groups, which you can view by querying the V_CATALOG.CLUSTER_LAYOUT
system table. This view also lets you see the proposed new layout for nodes in the cluster.
Syntax
REALIGN_CONTROL_NODES()
Privileges
Example
Choose control nodes from all cluster nodes and assign the remaining nodes to a control node:
=> SELECT REALIGN_CONTROL_NODES;
See Also
Defining and Realigning Control Nodes on an Existing Cluster