When you configure system parameter settings at the shard catalog, they are automatically propagated to all shards of the distributed 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 distributed 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;