"DFS lock handle" TA lock
716545Sep 23 2009 — edited Sep 23 2009My RAC is showing lots of "DFS lock handle" wait events. Seems that I'm apparently having trouble with some sequence. Google and Metalink advised me to run
SELECT SID, CHR(BITAND(P1,-16777216)/16777215)||
CHR(BITAND(P1, 16711680)/65535) "LOCK",
TO_CHAR(BITAND(P1, 65536)) "MODE",
P2, P3,SECONDS_IN_WAIT
FROM V$SESSION
WHERE EVENT = 'DFS lock handle';
And I get:
SID LOCK MODE P2 P3 SECONDS_IN_WAIT
---------- -------- -------------------- ---------- ---------- ---------------
598 TA 65536 3 475 0
SID LOCK MODE P2 P3 SECONDS_IN_WAIT
---------- -------- -------------------- ---------- ---------- ---------------
598 TA 65536 3 481 0
What is "TA" lock? There are some explanation on LOCKs but usually "CI" or "SS" is doumentened, not TA. Or am I having trouble with something else than sequence?
I know wait events are caused by PL/SQL executing... "begin :1 := JAVA_XA.xa_start_new(:2,:3,:4,:5,:6); end;" It doesn't help much...
Help?