RE: dfs Lock handle on RAC

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 30 Sep 2016 06:29:51 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90150341AEE_at_exmbx05.thus.corp>

Do you mean that DFS lock handle appeared in the top timed events, with a significant fraction of the time, and a summary of the p1 values from ASH (v$ or DBA_HIST) showed most of these to be BB or DX ?

They're both associated with distributed transactions - do you think you're doing distributed transactions ? If not, are you accidentally doing distributed transactions because your application is using XA and managing to direct parts of what it sees as the same transaction through difference app servers ?

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Sanjay Mishra [dmarc-noreply_at_freelists.org] Sent: 30 September 2016 00:50
To: Oracle-L Freelists
Subject: dfs Lock handle on RAC

Hi Experts

Can someone suggest what should be done if I am seeing some performance issue and found 'DFS Lock handle" and rdbms ipc Reply Event and digging more found that dfs Lock Handle has enqueue DX and BB. Can someone suggest what should be done on Database or Application side to resolve it.

Tx
Sanjay

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 30 2016 - 08:29:51 CEST