Propagation of Parameter Settings Across Shards
When you configure system parameter settings at the shard catalog, they are automatically propagated to all shards of the sharded database.
Oracle Globally Distributed Database provides centralized management by allowing you to set parameters on the shard catalog. Then the settings are automatically propagated to all shards of the sharded database.
Propagation of system parameters happens only if done under ENABLE SHARD DDL
on the shard catalog, then include SHARD=ALL
in the ALTER
statement.
SQL>alter session enable shard ddl;
SQL>alter system set enable_ddl_logging=true shard=all;
Note:
Propagation of theenable_goldengate_replication
parameter setting is not supported.