1.300 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 |
No |
|
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.
Note:
This initialization parameter is available starting with Oracle Database 12c Release 2 (12.2.0.1).
See Also:
-
Oracle Database Concepts for an introduction to sharding
-
Oracle Database Administrator’s Guide for more information about duplicated tables