REPLICATION_DEPENDENCY_TRACKING

Property	Description
Parameter type	Boolean
Default value	true
Modifiable	No
Range of values	true | false

REPLICATION_DEPENDENCY_TRACKING enables or disables dependency tracking for read/write operations to the database. Dependency tracking is essential for propagating changes in a replicated environment in parallel.

Values:

• TRUE

Enables dependency tracking.

• FALSE

Allows read/write operations to the database to run faster, but does not produce dependency information for Oracle to perform parallel propagation. Do not specify this value unless you are sure that your application will not perform any read/write operations to the replicated tables.

Note:

1. See also Oracle Database Advanced Replication for more information on parallel propagation dependency tracking

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'REPLICATION_DEPENDENCY_TRACKING';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
replication_dependency_tracking	TRUE	TRUE	FALSE	FALSE	FALSE		FALSE	tracking dependency for Replication parallel propagation

Oracle initializatoin parameters