1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. SHRD_DUPL_TABLE_REFRESH_RATE

1.316 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 SYSTEM

Modifiable in a PDB

No

Range of values

20 to 4294967295 (UB4MAXVAL)

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: