Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 11033 invoked from network); 17 Dec 2007 00:31:12 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 17 Dec 2007 00:31:12 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 863F47D9BFC; Mon, 17 Dec 2007 01:31:12 -0500 (EST) 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 17088-05-4; Mon, 17 Dec 2007 01:31:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D75877D9CB0; Mon, 17 Dec 2007 01:31:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 17 Dec 2007 00:43:46 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D554B7D9AF0 for ; Mon, 17 Dec 2007 00:43:46 -0500 (EST) 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 08998-10 for ; Mon, 17 Dec 2007 00:43:46 -0500 (EST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3C2BC7D9D63 for ; Mon, 17 Dec 2007 00:43:45 -0500 (EST) Received: by ug-out-1314.google.com with SMTP id y2so1846428uge.37 for ; Sun, 16 Dec 2007 21:43:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=w+wm3KOuCXc+bqfvDqDeWHEx5Yg4LC2X/nXmD90gAFU=; b=Bc6bxebP6EaTQZzq/yjCxXV7xBx3uuzES7I5fTyZknbyQijgYEGqHp2d6OVidKCKT7C8xNUHDeHyeF7jssh7QC+c0+Hd4pfcKuzhGJeDtKP1KEWibp43sB8VgSHx/k6T9czWhOOHICb75yUdPPeQflpPRpLBRDLQjACrSqhzftY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=v91CbSKf5jwLVbXb1NJ8+H2hRFZrRVvdPnd1g+Pag5F4AR/OrRWNR9iRB9tchYw4dosI+Gxx8DeXgAknR/hTBaP6EU6cyVbZKv28pyLyxQmoQVuVJTDBUfdIrBlJ4+0+B1WZN/n+Bx5Wj59nHOt100HhTOMuhJR5pS2E7aPP1U8= Received: by 10.67.106.19 with SMTP id i19mr3536771ugm.67.1197870224921; Sun, 16 Dec 2007 21:43:44 -0800 (PST) Received: by 10.67.122.20 with HTTP; Sun, 16 Dec 2007 21:43:44 -0800 (PST) Message-ID: <4415a5ed0712162143h3f2ec6eaj604c7e42a720e9e9@mail.gmail.com> Date: Mon, 17 Dec 2007 13:43:44 +0800 From: "Eagle Fan" To: "Bobak, Mark" Subject: Re: what's "enq:TX - contention" Cc: oracle-l In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17612_5097376.1197870224909" References: <4415a5ed0711260819m23f288c4j1963d3ca108cf07b@mail.gmail.com> <4415a5ed0711290005r4217052bmcf669f41c15bc0f3@mail.gmail.com> X-archive-position: 3963 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: eagle.f@gmail.com Precedence: normal Reply-to: eagle.f@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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_17612_5097376.1197870224909 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline The sessions were waiting on TX-4. We can't find the blocker. Thanks On Nov 30, 2007 12:04 AM, Bobak, Mark wrote: > When this is happening, in what mode is the lock being held? (I assume > 'X'.) In what mode is the waiting lock? ('S' mode?) > > > > -Mark > > > > *-- > Mark J. Bobak* > *Senior Database Administrator, System & Product Technologies* > ProQuest > 789 E. Eisenhower, Parkway, P.O. Box 1346 > Ann Arbor MI 48106-1346 > +1.734.997.4059 or +1.800.521.0600 x 4059 > mark.bobak@il.proquest.com > www.proquest.com > www.csa.com > > *ProQuest...*Start here. > > > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Eagle Fan > *Sent:* Thursday, November 29, 2007 3:05 AM > *To:* oracle-l > *Subject:* Re: what's "enq:TX - contention" > > > > any comments? > > Thanks > > On Nov 27, 2007 12:19 AM, Eagle Fan wrote: > > hi: > > > > In 10g, oracle has four TX wait events: > > > > 1. enq:TX - row lock contention > > 2. enq:TX - index contention > > 3. enq:TX - ITL > > 4. enq:TX - contention > > > > I know the first three ones' meanings. > > > > But what does the last one "enq:TX - contention" mean? I know it means > other TX enqueue types. But what's the *other* TX enqueues? > > > > Could anybody give me some examples? We have insert sql causes this TX > contention. > > > > I searched metalink and oracle-l, but most doc/threads are discussing the > first three ones. > > > > Thanks a lot. > > -- > Eagle Fan > > Oracle DBA > > > > > -- > Eagle Fan > > Oracle DBA > -- Eagle Fan Oracle DBA ------=_Part_17612_5097376.1197870224909 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline The sessions were waiting on TX-4.

We can't find the blocker.

Thanks

On Nov 30, 2007 12:04 AM, Bobak, Mark <Mark.Bobak@il.proquest.com > wrote:

When this is happening, in what mode is the lock being held?  (I assume 'X'.)  In what mode is the waiting lock?  ('S' mode?)

 

-Mark

 

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Eagle Fan
Sent: Thursday, November 29, 2007 3:05 AM
To: oracle-l
Subject: Re: what's "enq:TX - contention"

 

any comments?

Thanks

On Nov 27, 2007 12:19 AM, Eagle Fan <eagle.f@gmail.com> wrote:

hi:

 

In 10g, oracle has four TX wait events:

 

1. enq:TX - row lock contention

2. enq:TX - index contention

3. enq:TX - ITL

4. enq:TX - contention

 

I know the first three ones' meanings.

 

But what does the last one "enq:TX - contention" mean? I know it means other TX enqueue types. But what's the *other* TX enqueues?

 

Could anybody give me some examples? We have insert sql causes this TX contention.

 

I searched metalink and oracle-l, but most doc/threads are discussing the first three ones.

 

Thanks a lot.

--
Eagle Fan

Oracle DBA




--
Eagle Fan

Oracle DBA




--
Eagle Fan

Oracle DBA ------=_Part_17612_5097376.1197870224909-- -- http://www.freelists.org/webpage/oracle-l