DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: why DX lock is happening ?

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Drop dblink temporarily.
    And see WebLogic produces an error.

    Tamil

  3. #3
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    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

  4. #4
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    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
  •  


Click Here to Expand Forum to Full Width