Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 17715 invoked from network); 4 Dec 2007 15:11:53 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 4 Dec 2007 15:11:53 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8CDBF7D1663; Tue, 4 Dec 2007 16:11:53 -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 04307-08; Tue, 4 Dec 2007 16:11:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EAB757D16E9; Tue, 4 Dec 2007 16:11:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 Dec 2007 16:09:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2D6427D15FE for ; Tue, 4 Dec 2007 16:09:45 -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 03679-07 for ; Tue, 4 Dec 2007 16:09:45 -0500 (EST) Received: from nys17a-3001.corpny.csfb.com (mail-gw16.credit-suisse.com [198.240.130.181]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 006187D1548 for ; Tue, 4 Dec 2007 16:09:44 -0500 (EST) Received: by nys17a-3001.corpny.csfb.com; Tue, 4 Dec 2007 16:08:42 -0500 (EST) X-Server-Uuid: 13D18DBC-9E45-4B21-A894-493F5AF71AE6 Content-class: urn:content-classes:message MIME-Version: 1.0 X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: RE: How accurate is ADDM? Date: Tue, 4 Dec 2007 16:08:33 -0500 Message-ID: <21469B88E0EA11498818517F21033531DEF8A9@EPRI17P32001A.csfb.cs-group.com> In-Reply-To: <2B4E386EAEC90947802323BF373DC0EC0CEEF92A@sottemail1.ent.ad.cognos.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How accurate is ADDM? References: <2B4E386EAEC90947802323BF373DC0EC0CEEF92A@sottemail1.ent.ad.cognos.com> From: "Baumgartel, Paul" To: David.Best@cognos.com, oracle-l@freelists.org X-OriginalArrivalTime: 04 Dec 2007 21:08:33.0873 (UTC) FILETIME=[D44D1410:01C836B9] X-WSS-ID: 6B4B1E5B428138739-01-05 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 3701 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: paul.baumgartel@credit-suisse.com Precedence: normal Reply-to: paul.baumgartel@credit-suisse.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 Have you confirmed the write time by generating an AWR report for that time period and seeing what the average wait for log file parallel write and log file sync is? Paul Baumgartel CREDIT SUISSE Information Technology Securities Processing Databases Americas One Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@credit-suisse.com www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Best, David Sent: Tuesday, December 04, 2007 3:21 PM To: oracle-l@freelists.org Subject: How accurate is ADDM? Hey all, How accurate is ADDM? Today we had a severe performance issue with one our of databases. The ADDM recommendation for that period put the most weight on the following: ---[ADDM Snip]--- Action Investigate the possibility of improving the performance of I/O to the online redo log files. Rationale The average size of writes to the online redo log files was 932 K and the average time per write was 3020 milliseconds. ---[ADDM Snip]--- The problem is, our storage team doesn't see the same level of degredation. Any suggestions? tnx -- http://www.freelists.org/webpage/oracle-l ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- http://www.freelists.org/webpage/oracle-l