DISTRIBUTED_LOCK_TIMEOUT

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================

Property	Description
Parameter type	Integer
Default value	60
Modifiable	No
Range of values	1 to unlimited
Basic	No

DISTRIBUTED_LOCK_TIMEOUT specifies the amount of time (in seconds) for distributed transactions to wait for locked resources.
Note:
1. This parameter was hidden in 8i and 9.0 and then made available again in 9.2 onwards. The parameter defines the number of seconds that a distributed transaction waits for a lock. If a session waits longer than this for the lock then ORA-2049 is signalled.
2. This timeout applies even to local lock waits if the session is in a distributed transaction. See Metalink Note 19332.1 for an example.
3. This parameter can be useful to set a time-limit on statements. The session only needs to be using a DBLINK for this behaviour (timeouts) to be enabled.
4. 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) = ‘DISTRIBUTED_LOCK_TIMEOUT’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
distributed_lock_timeout	60	TRUE	FALSE	FALSE	FALSE	FALSE	number of seconds a distributed transaction waits for a lock

Oracle initializatoin parameters