1.327 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 |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
20 to 231 - 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:
-
Using Oracle Sharding for an introduction to sharding
-
Using Oracle Sharding for more information about duplicated tables