• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • oracle deadlock rac from weblogic transactions

    Recently a table in my database was in the lock. I am using Oracle RAC and transactions sent to the database are managed by WebLogic 10.3.0. I have configured the multiple data sources and my transaction has enabled the options “Supports Global Transaction” and “One-Phase Commit”. After that table was in the lock, I don’t why the WebLogic don’t kill this transaction, my questions here are:

    1 - What’re the possibles reasons to ORACLE RAC lock the table based on my connection pool configurations?

    2 - Why Weblogic didn’t kill the transaction after the timeout (for this case I have the timeout set with 30s) ?

    More Info: I’m using a thin driver to connect Weblogic with Oracle RAC

    For this scenario, I didn’t see an error related to deadlock or something like this on logs.
    Thanks.

    Great post! Your article provides nice information about Oracle RAS.Thank you for sharing such a nice infotmative blog…keep share more