Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 28903 invoked from network); 10 Oct 2006 14:50:57 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 10 Oct 2006 14:50:56 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFE07446BEA;
 Tue, 10 Oct 2006 15:50:21 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 05942-03-6; Tue, 10 Oct 2006 15:50:21 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 45917446BDD;
 Tue, 10 Oct 2006 15:50:21 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 10 Oct 2006 15:49:23 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72B1C446B7F
 for <oracle-l@freelists.org>; Tue, 10 Oct 2006 15:49:23 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 05600-07 for <oracle-l@freelists.org>;
 Tue, 10 Oct 2006 15:49:23 -0400 (EDT)
Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.193])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4EF2A446B73
 for <oracle-l@freelists.org>; Tue, 10 Oct 2006 15:49:23 -0400 (EDT)
Received: by nz-out-0102.google.com with SMTP id o37so509267nzf
        for <oracle-l@freelists.org>; Tue, 10 Oct 2006 12:49:58 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=CajJjYO6RRbZZF26NHw0cpfGmwP7qoZLPBSAJFvbTmsCCqeTfL95q0jury/E2KIyuSY3q+MWZ/0WI60fs988ibxet13YBJWKX7Hy5aKMKyPINjMrr5w7j9KnBnFmCtxOTk/Ilc/Uia/ug8zxpc+YUzSiugSQG4tRs5ZHuE3XpLI=
Received: by 10.65.214.19 with SMTP id r19mr11900004qbq;
        Tue, 10 Oct 2006 12:49:57 -0700 (PDT)
Received: by 10.64.178.5 with HTTP; Tue, 10 Oct 2006 12:49:57 -0700 (PDT)
Message-ID: <b4d52f20610101249q2d9f77f7u60f5ec8d440dcb2f@mail.gmail.com>
Date: Tue, 10 Oct 2006 15:49:57 -0400
From: "Richard Ji" <richard.c.ji@gmail.com>
To: oracle@digistar.com
Subject: Re: log file sync
Cc: oracle-l@freelists.org
In-Reply-To: <Pine.GSO.4.58.0610101500570.9570@digistar.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_11265_27033951.1160509797078"
References: <Pine.GSO.4.58.0610101500570.9570@digistar.com>
X-archive-position: 40568
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: richard.c.ji@gmail.com
Precedence: normal
Reply-to: richard.c.ji@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_11265_27033951.1160509797078
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What kind of application is that?  Java?  If that's the case, make sure he
turns off auto commit.  Otherwise despite his change, it's still committing
frequently.  The same thing might apply to other language too.

Richard

On 10/10/06, oracle@digistar.com <oracle@digistar.com> wrote:
>
>
> hi,
>
> I am trying to uncover the root cause of log file sync waits causing an
> application to decrease in performance.  10046 trace shows hundreds of
> thousands of lines of log file sync with ela time around 1000.  1ms by
>
>
>
>

------=_Part_11265_27033951.1160509797078
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What kind of application is that?&nbsp; Java?&nbsp; If that's the case, make sure he turns off auto commit.&nbsp; Otherwise despite his change, it's still committing frequently.&nbsp; The same thing might apply to other language too.<br><br>Richard
<br><br><div><span class="gmail_quote">On 10/10/06, <b class="gmail_sendername"><a href="mailto:oracle@digistar.com">oracle@digistar.com</a></b> &lt;<a href="mailto:oracle@digistar.com">oracle@digistar.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>hi,<br><br>I am trying to uncover the root cause of log file sync waits causing an<br>application to decrease in performance.&nbsp;&nbsp;10046 trace shows hundreds of
<br>thousands of lines of log file sync with ela time around 1000.&nbsp;&nbsp;1ms by<br><br><br><br></blockquote></div><br>

------=_Part_11265_27033951.1160509797078--
--
http://www.freelists.org/webpage/oracle-l