Received: (qmail 15213 invoked from network); 3 Mar 2012 10:12:18 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 3 Mar 2012 10:12:15 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28094E9F758; Sat, 3 Mar 2012 11:12:15 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1330791135; bh=VE8NmwOhBSgF8B1Av7ELxXnsMYBE51whYDJc4uVp jq0=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-type:Content-Transfer-Encoding:Sender:Reply-To: List-help:List-unsubscribe:List-Id:List-subscribe:List-owner: List-post:List-archive; b=OBiwIakjBGyWiZbNHSiPrxyDPnnjPX6RI5oZm2dq nYZy1LQFgw3120pSDDSHDwRttCIqODLCyMVn3uKI1J1GT/OoGfGrMlbXtELY58kkOXp RnWyZSJfDZNTMMT+29zaxxHx0ow6FT3nse/zoRGkbg96S5EDgwB+MgJBofTHO2gk= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id vDW7ELskAKjQ; Sat, 3 Mar 2012 11:12:14 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4443CE9F6C5; Sat, 3 Mar 2012 11:11:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 03 Mar 2012 11:10:51 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7ACE5E9F50D for ; Sat, 3 Mar 2012 11:10:50 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key) header.i=@gmail.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1udT4kOpTuqV for ; Sat, 3 Mar 2012 11:10:50 -0500 (EST) Received: from mail-iy0-f179.google.com (mail-iy0-f179.google.com [209.85.210.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 20B42E9AD10 for ; Sat, 3 Mar 2012 11:10:49 -0500 (EST) Received: by iakh37 with SMTP id h37so3653449iak.10 for ; Sat, 03 Mar 2012 08:10:49 -0800 (PST) Received-SPF: pass (google.com: domain of huanshengchen@gmail.com designates 10.50.186.198 as permitted sender) client-ip=10.50.186.198; Authentication-Results: mr.google.com; spf=pass (google.com: domain of huanshengchen@gmail.com designates 10.50.186.198 as permitted sender) smtp.mail=huanshengchen@gmail.com; dkim=pass header.i=huanshengchen@gmail.com Received: from mr.google.com ([10.50.186.198]) by 10.50.186.198 with SMTP id fm6mr1972814igc.40.1330791049786 (num_hops = 1); Sat, 03 Mar 2012 08:10:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=8K4e4IoanbWpsN1rd3Wm7DM4jciGL2wpR+JciOssKw8=; b=scqiHaJcQZfYn5g0VdulB7XtEueJAmueXlUD8DKQEMN/K5PwFQG11wsbjwLNqntXoA 5o3w2xJgqyCnGGkJOaN5PCKaJAWVu/NEZmrdn3Qvzomd9E5Xq76uUQMmSuVblkYGhLlj Z0TLHLxhv7cDFYqdSwGHI0/gb2GBrMItxQJV5p9zFksaXjb16D0IZST/jYql7ROWXnKa 7pz8qMw4v5hpQz/nw6gXEBlOykXBWCrIa/J1x3yC7NQiGzI4sAdhBchuZEEG435o45Jf a6jU3wAnFVYcoeKiS2EmdYptUtTggWRozNeki9pUlmWACZiLWLpS2QifD3yVj8+GAPvR VQ0Q== MIME-Version: 1.0 Received: by 10.50.186.198 with SMTP id fm6mr1639404igc.40.1330791049749; Sat, 03 Mar 2012 08:10:49 -0800 (PST) Received: by 10.50.72.147 with HTTP; Sat, 3 Mar 2012 08:10:49 -0800 (PST) In-Reply-To: References: <07CD5CD8DFD44E0F8C94ECF2B88ADE1F@Primary> Date: Sun, 4 Mar 2012 00:10:49 +0800 Message-ID: Subject: Re: TM Contention (locks type 2, 3, 6) From: Sidney Chen To: exriscer@gmail.com Cc: jonathan@jlcomp.demon.co.uk, Oracle Mailinglist Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 41682 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: huanshengchen@gmail.com Precedence: normal Reply-To: huanshengchen@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l 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-l