Re: TM Contention (locks type 2, 3, 6)

  • From: Sidney Chen <huanshengchen@xxxxxxxxx>
  • To: Ls Cheng <exriscer@xxxxxxxxx>
  • Date: Tue, 6 Mar 2012 22:35:54 +0800

Have you get the sql running by the blocked session?
On Tue, Mar 6, 2012 at 9:29 PM, Ls Cheng <exriscer@xxxxxxxxx> wrote:

> umm all FKs are enabled
>
> thanks
>
>
> On Sat, Mar 3, 2012 at 5:10 PM, Sidney Chen <huanshengchen@xxxxxxxxx>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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2012