1.341 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