Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 7F082100392706 for ; Sun, 2 Feb 2020 07:30:28 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4A6D267D2; Sun, 2 Feb 2020 01:30:26 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1580625027; bh=jFZuqjPEOldODjqm/Jc/S1xfXsgZsGVWDRFEnam4HDw=; h=From:Sender:Sender:From; b=d4Q9TR6JEj56PXXRfErXzvEk1dQW89crqJ/Gbe9kh8NkvdDFsJBojkKG3euhyBgft 6V24kJUcnF3faQb7cBfcviTlxFnuas5cMyG5FQoOim9RyMI4Io5KKCuQiIU/NbmloR gBvhsknlmmIQMxIHtvD0Kq9eEGAVjQVZAqvrYoKo= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org 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 c3lDe_6gnUBE; Sun, 2 Feb 2020 01:30:26 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ACE80267E1; Sun, 2 Feb 2020 01:29:38 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1580625023; bh=jFZuqjPEOldODjqm/Jc/S1xfXsgZsGVWDRFEnam4HDw=; h=From:Sender:Sender:From; b=E7Opa7IFg83hLmQlVEuLlfTN11S72a4/e2PYN8zEzD8ntmj/ZQY8s/gsoA8pi1AQH rohILxkjOfOQ4zQakUMr6Hvr/Ug8V/7tlg76HPkqURLfKJsJeiIw4Im0NLqh/DB2V2 3hErarAxdlaOPy8MqeMGxBqQBz6ZxWqAEdzgDHZw= Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 02 Feb 2020 01:28:53 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7C97C267C6 for ; Sun, 2 Feb 2020 01:28:53 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.b="aFQjMP/W"; dkim-atps=neutral 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 GykjcK98zjLN for ; Sun, 2 Feb 2020 01:28:53 -0500 (EST) Received: from mail-qk1-f174.google.com (mail-qk1-f174.google.com [209.85.222.174]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 42A5826772 for ; Sun, 2 Feb 2020 01:28:53 -0500 (EST) Received: by mail-qk1-f174.google.com with SMTP id q15so11103631qki.2 for ; Sat, 01 Feb 2020 22:28:53 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=pXfR3gThLnmH9i0nPkOAL9weik/R2B6V6kpIvpeIQXg=; b=lRI+gqCL8wWvCoanPtfN2hKv7m2iEqPh1ngkIXJV2WUVF100E9Ma6+qOeGjNWVxAJF eSRTTf7Wu0JjeWS37Q3P2esUdBOjNmKNrRCQwQKOx1Kuul78fb+KOSVViB6R5Y5KxYiY C90DPCGDUQdJg9Og+sVoDdtDgZs3oto5RqY+TjgxerNuaWTi4pL9QmIF/uxOtYnZRwfO mV4RQh0tUeL+sUw0MrvY23Pfr40c1scxquDMLgB7JMqI8KG410jSydZVi3z8ULPe+e7b tJGunTggusfJpBab9jCFHo/y/cWI7aMzJFo/kCwJoVc/pHLoZ2G5Cul50RVYnC9XjLs6 PbUg== X-Gm-Message-State: APjAAAUWM+UjQAVOa/q4Xchj5RNo8Hr8cKp95l7u6+iNwagNpD9h/Qbl rZEjgos1B8n4S++lgyCSK1lj+GDz X-Google-Smtp-Source: APXvYqxByE1rrZiGsiyHlCRGGsCKWRvdoPv3IGE4cnHN3kG96SpwnhghsDNtSyhdGTtSqRvfqCVbdA== X-Received: by 2002:ae9:c205:: with SMTP id j5mr17653591qkg.58.1580624931938; Sat, 01 Feb 2020 22:28:51 -0800 (PST) Received: from [192.168.2.7] (pool-100-8-173-246.nwrknj.fios.verizon.net. [100.8.173.246]) by smtp.gmail.com with ESMTPSA id t29sm7288129qkm.27.2020.02.01.22.28.51 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 01 Feb 2020 22:28:51 -0800 (PST) Subject: Re: intermittent long "log file sync" waits To: oracle-l@freelists.org References: <38763_1580228753_5E306091_38763_12713_1_cf89e1868e2e40949f6177bf1c604696@vontobel.com> <39760_1580232621_5E306FAD_39760_6519_1_238f704e660247f78d5e2f6a5c98b27f@vontobel.com> <38763_1580238546_5E3086D2_38763_18592_1_8d9cba2aa89d4aba82f0b60173245848@vontobel.com> From: Mladen Gogala Message-ID: <7d41a1e0-22f6-0bca-e2c7-da793259471c@gmail.com> Date: Sun, 2 Feb 2020 01:28:50 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-archive-position: 76129 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: gogala.mladen@gmail.com Precedence: normal Reply-To: gogala.mladen@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 And some bugs, too. Race condition between LGWR slaves are not out of the question: Bug 21915719 - 12c Hang: LGWR waiting for 'lgwr any worker group' or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2] on IBM AIX / HPIA (Doc ID 21915719.8) Bug 9916044: ALOT OF LOG FILE SYNC AFTER APPLYING 11.1.0.7.3 This bug 9916044 suggest to apply latest PSU. So I would recommend you to apply the latest PSU patch on 11.1.0.7 which is 9952228 - 11.1.0.7.5 Patch Set Update (PSU) Of course, there is also a cryptic message "Private strand flush not complete" Long story short, if there are many "log file sync" events and you think they shouldn't be present in such number, please open performance case with Oracle support. And while it is true that "log file sync" doesn't measure only I/O, it mostly depends on I/O. On 2/1/20 10:50 PM, Tanel Poder wrote: > But in 12c there are more moving parts. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-l