-
why DX lock is happening ?
hi all,
I am facing very strange behaviour in my database. As I know that there should not be any
distributed transaction. But I am getting DX locks. Now I want to know the reason why?
I have checked the sessions who are producing DX locks. These sessions are connected to
our database through WebLogic server.
I have also checked the following things :
select * from v$sysstat where statistic# in (239,240,241)
STATISTIC# NAME CLASS VALUE
239 bytes sent via SQL*Net to dblink 1 0
240 bytes received via SQL*Net from dblink 1 0
241 SQL*Net roundtrips to/from dblink 1 0
select * from v$sesstat where statistic# in (239,240,241) and value > 0
no rows selected
The above result shows that there is no instance of DB Links.
I want to know the possible reasons for which I am facing such locks.
For information, I have got this lock against one insert statement.
The environment is Oracle 9i rel2 , Sun Solaris 9 and weblogic server 6.1 sp 4
Deba
-
Drop dblink temporarily.
And see WebLogic produces an error.
Tamil
-
Hi tamilselvan,
You have not gone through my problem properly. We are not using any dblink. But still we are getting DX lock. Why ?
For your info we are using XA connections in Weblogic server.
Deba
-
For additional info on weblogic setup :
There are 2 connection pools : A and B
In connection pool A We are using following driver classname :
weblogic.jdbc.oci.xa.XADataSource
There is one TX Data source called SSTXDatasource, in which we are referring connection pool A and here two-phase coomit option is not checked but we have enabled row prefetch option.
Is the above setting is responsible for creating DX locks in my Oracle database ?
Deba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|