bssarnma
asked on
How to find out the value for Timeout in Oracle
Hi,
I want know where the parameter is stored in the oracle database for - the maximum time for which the oracle server waits for obtaining a lock (incase of dead locks etc).
Can I modify this parameter?
(I think the param is TIMEOUT_ON_RESOURCE)
Thanks in advace.
Sarma
I want know where the parameter is stored in the oracle database for - the maximum time for which the oracle server waits for obtaining a lock (incase of dead locks etc).
Can I modify this parameter?
(I think the param is TIMEOUT_ON_RESOURCE)
Thanks in advace.
Sarma
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The parameter
DISTRIBUTED_LOCK_TIMEOUT
controls distributed timeouts -- any transaction that needs to lock remote resources will give up if no lock is obtained after this many seconds.
You set it in your INIT.ORA file. Inspect its current setting in the table
V$PARAMETER
PL/SQL uses a named exception, TIMEOUT_ON_RESOURCE, which maps to ORA-00051, that is as far as I know not configurable.
DISTRIBUTED_LOCK_TIMEOUT
controls distributed timeouts -- any transaction that needs to lock remote resources will give up if no lock is obtained after this many seconds.
You set it in your INIT.ORA file. Inspect its current setting in the table
V$PARAMETER
PL/SQL uses a named exception, TIMEOUT_ON_RESOURCE, which maps to ORA-00051, that is as far as I know not configurable.
ASKER
Thank you.
ASKER
Thanks.
How do I see where the time out value is specified?? (for distributed queries / PL/sql operations).
Can I modify this value??
bye
Sarma