SHRD_DUPL_TABLE_REFRESH_RATE

SHRD_DUPL_TABLE_REFRESH_RATE displays the duplicated table refresh rate (in seconds).

Property	Description
Parameter type	Integer
Default value	`60`
Modifiable	`ALTER SESSION`, `ALTER SYSTEM`
Modifiable in a PDB	Yes
Range of values	20 to 2³¹ - 1
Basic	No
Oracle RAC	All instances should use the same instance.

You can change the value of this parameter to change the duplicated table refresh rate.

A duplicated table is a table that has the same contents on all shards in a sharded database. Duplicated tables are implemented using materialized views that are refreshed at a certain rate.

See Also:

Oracle Globally Distributed AI Database for an introduction to sharding
Oracle Globally Distributed AI Database for more information about duplicated tables