Re: TM Contention (locks type 2, 3, 6)
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 6 Mar 2012 14:29:23 +0100
Message-ID: <CAJ2-Qb-mfPNx+W9gvUtFLxtZSzg4QqEiwUvgdHreEHrwKWD-vA_at_mail.gmail.com>
umm all FKs are enabled
thanks
Date: Tue, 6 Mar 2012 14:29:23 +0100
Message-ID: <CAJ2-Qb-mfPNx+W9gvUtFLxtZSzg4QqEiwUvgdHreEHrwKWD-vA_at_mail.gmail.com>
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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 06 2012 - 07:29:23 CST