MAX_COMMIT_PROPAGATION_DELAY

Property	Description
Parameter type	Integer
Default value	0
Modifiable	No
Range of values	0 to 90000
Basic	No
Real Application Clusters	Multiple instances must have the same value.

The MAX_COMMIT_PROPAGATION_DELAY parameter is deprecated. It is retained for backward compatibility only.

MAX_COMMIT_PROPAGATION_DELAY is a Real Application Clusters parameter. This initialization parameter should not be changed except under a limited set of circumstances specific to the cluster database.
Note:
1. 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) = ‘MAX_COMMIT_PROPAGATION_DELAY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
max_commit_propagation_delay	0	TRUE	FALSE	FALSE	FALSE	TRUE	Max age of new snapshot in .01 seconds

Oracle initializatoin parameters

More Oracle DBA tips, please visit Oracle DBA Tips