Re: TM Contention (locks type 2, 3, 6)
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Tue, 6 Mar 2012 22:35:54 +0800
Message-ID: <CAM_ddu8nfCks-t2VCh+ecGG_OLJK0k6Vq-KPOwuhXw9jcEVnKQ_at_mail.gmail.com>
Have you get the sql running by the blocked session? On Tue, Mar 6, 2012 at 9:29 PM, Ls Cheng <exriscer_at_gmail.com> wrote:
Date: Tue, 6 Mar 2012 22:35:54 +0800
Message-ID: <CAM_ddu8nfCks-t2VCh+ecGG_OLJK0k6Vq-KPOwuhXw9jcEVnKQ_at_mail.gmail.com>
Have you get the sql running by the blocked session? On Tue, Mar 6, 2012 at 9:29 PM, Ls Cheng <exriscer_at_gmail.com> wrote:
> umm all FKs are enabled
>
> thanks
>
>
> On Sat, Mar 3, 2012 at 5:10 PM, Sidney Chen <huanshengchen_at_gmail.com>wrote:
>
>> If you check sid for the blocked session which request mode is 6, and
>> check the v$session.sql_id, you should get the sql attempting the acquire
>> the TM lock in mode 6.
>>
>> Have you check the status for the FK, if it's disabled, direct path
>> insert will be still honored.
>>
>> --
>> Regards
>> Sidney Chen
>>
>>
>>
>
-- Regards Sidney Chen -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 06 2012 - 08:35:54 CST