Re: DFS lock wait

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 6 Oct 2011 08:17:39 -0400
Message-ID: <CAGurbTOQwOSibSv6-kZheJntqCiNsh=gUjPvJrYk845B529dTQ_at_mail.gmail.com>

Also forgot to add, We do use XA but all sessions for that app _always_ connect to a single node. That is how app is partitioned. Raj

On Thu, Oct 6, 2011 at 8:00 AM, rjamya <rjamya_at_gmail.com> wrote:

> Single Record View As of: 10/6/2011 7:51:43 AM
> EVENT: DFS lock handle
> P1TEXT: type|mode
> P1: 1146617861
> P1RAW: 0000000044580005
> P2TEXT: id1
> P2: 3376176309
> P2RAW: 00000000C93C5CB5
> P3TEXT: id2
> P3: 0
> P3RAW: 00
> WAIT_CLASS_ID: 1893977003
> WAIT_CLASS#: 0
> WAIT_CLASS: Other
> WAIT_TIME: 0
> SECONDS_IN_WAIT: 0
> STATE: WAITING
>
> The lock is always DX or BB and mode is always 5.
>
> Raj
> On Thu, Oct 6, 2011 at 7:43 AM, <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>> What's the actual lock for ? (in other words, what's the p1raw value)
>>
>> Regards
>> Jonathan Lewis
>>
>>

-- 
-----
Best regards
Raj


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

Received on Thu Oct 06 2011 - 07:17:39 CDT