Database Reference
In-Depth Information
for adapter deployments. Furthermore, the properties set
in the
.jca
file at design time can be overridden at
runtime from Oracle Enterprise Manager Fusion Middle-
ware Control.
Tuning database for XA Transaction Timeout
The next step to tune transactional behavior at the infrastructure level is to
verify the
distributed_lock_timeout
value in the database. It specifies
the amount of time for distributed transactions to wait for locked resources. The
value for this database parameter should be set to a value greater than
XA
Transaction Timeout
. To see and alter this value in the database, follow
these steps:
1.
Connect to the Oracle SOA Suite 11g database
sys
schema table as
sys-
dba
.
2.
Execute this SQL command to see the default value of the
distrib-
uted_lock_timeout
parameter in seconds:
SQL>SHOW PARAMETER DISTRIBUTE_LOCK_TIMEOUT;
3.
The default value of the parameter is 60 seconds and to increase it run the
following statement:
SQL>ALTER SYSTEM SET DISTRIBUTE_LOCK_TIMEOUT=3600 SCOPE=SPFILE;
4.
Shut down and then restart the database.
5.
In the event that you are connecting to an Oracle
Real Application Cluster
(RAC)
, set this parameter to the same value for all the nodes in the RAC
cluster.
