Re: DISTRIBUTED_LOCK_TIMEOUT

Whenever you find this kind of problem, try adding _ at the front. In this case, it works.

Find all undocumented parameters for your database version and store them somewhere convenient to you:

select

	a.ksppinm  "Parameter",  
	a.ksppdesc "Description", 
	b.ksppstvl "Session Value",
	c.ksppstvl "Instance Value"
from 
	x$ksppi a, 
	x$ksppcv b, 
	x$ksppsv c
where 
	a.indx = b.indx 
	and a.indx = c.indx
	and a.ksppinm like '/_%' escape '/';

Oracle needs to update their documentation for the chapter "Managing Distributed Transactions".

Yong Huang
yong321_at_yahoo.com

mmouradi1_at_hotmail.com (Maher) wrote in message news:<4cbef54e.0108011440.9351391_at_posting.google.com>...
> It used to be that we can set this in init.ora to override 60-seconds
> timeout for distributed transactions.
>
> this no longer works in 8.1.7 since it is obsolete.
>
>
> any alternatives?
>
> Thanks in advance.
Received on Wed Aug 01 2001 - 23:04:58 CDT