Re: DFS lock wait

From: rjamya <rjamya_at_gmail.com>
Date: Sun, 9 Oct 2011 21:16:06 -0400
Message-ID: <CAGurbTN5r+PbaU9H5Kf2GnUVWkQpNQvT-5cocyKEyk2bTDLihQ_at_mail.gmail.com>

Thanks Riyaj,
Yes we do use but application is guaranteed to connect to only one node when active. So, we asked Oracle, but no reply from OWS after 8-10 days, hence i thought I'll check here. We are testing it in our test environment but still the knowledge-base on the list is amazing.

Thanks again
Raj

On Sun, Oct 9, 2011 at 12:46 PM, Riyaj Shamsudeen < riyaj.shamsudeen_at_gmail.com> wrote:

> Hello Raj
> You probably know this, but this is a new feature (11.2) in which XA
> transactions span across multiple instances with GTX background process
> (btw, this leads to interesting side effects). If you are not using this new
> feature, I don't see an issue disabling the feature.
> I am sure, this is probably a bug, but if you aren't sure, try disabling
> the feature and test it.
> Cheers
>
> Riyaj Shamsudeen
> Principal DBA,
> Ora!nternals - http://www.orainternals.com - Specialists in Performance,
> RAC and EBS11i
> Blog: http://orainternals.wordpress.com
> Oracle ACE Director and OakTable member http://www.oaktable.com
>
> Co-author of the books: Expert Oracle Practices<http://tinyurl.com/book-expert-oracle-practices/>,
> Pro Oracle SQL, Expert PL/SQL Practices<http://tinyurl.com/book-expert-plsql-practices>
>
>
>
> On Thu, Oct 6, 2011 at 7:17 AM, rjamya <rjamya_at_gmail.com> wrote:
>
>> 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
>>
>>
>>
>

-- 
-----
Best regards
Raj


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

Received on Sun Oct 09 2011 - 20:16:06 CDT