Received: (qmail 8288 invoked from network); 9 Sep 2011 23:26:51 -0500 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; 9 Sep 2011 23:26:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8938DE3FE87; Sat, 10 Sep 2011 00:26:41 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1315628801; bh=+3e4JYwUsf2jriAQr/iNICFQZQ/d/9ov66g3BtsX 74Q=; 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=rpUwMbHduDLf2JuD5CItgY93mMZm+vqbwSl0wYvY PdPoCsVNHKzrv0u+BzUBo9uafqVH95XRsNckw5aVIc8vwFUyoJkTmOz16/xpclsFBJz H5Pg+ATAxgMoo+0JeeuJGlonwTDs46kNvDujSgcRh8kFcZtlLSlD9ZIl1oM5xho0= 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 cMPCur-8bhlc; Sat, 10 Sep 2011 00:26:41 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C1B6E3FDFF; Sat, 10 Sep 2011 00:25:58 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 10 Sep 2011 00:25:16 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9FCF9E3FBBE for ; Sat, 10 Sep 2011 00:25:15 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (1024-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 iHfOHeK9lPBP for ; Sat, 10 Sep 2011 00:25:15 -0400 (EDT) Received: from mail-bw0-f51.google.com (mail-bw0-f51.google.com [209.85.214.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6AF8EE3ECC2 for ; Sat, 10 Sep 2011 00:25:11 -0400 (EDT) Received: by bkbzu17 with SMTP id zu17so224700bkb.10 for ; Fri, 09 Sep 2011 21:25:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=Brkxupr18DjRGHSfpyMjCoLpFn3YQ/ECgSJbG/DUFUw=; b=jQ1maBSloN0aoApb40cbO1JHW3uNy94Kx0iWwT/0vdb69uKMGF+pu7GouwIw0dNJVF TJDnv3US5OVcdYWf1saUFNRUmaqtN65MG28yKUbM7Gfq+wlaIEUS2Zs6MIkLrvpVlxDD hlNfftGBKyV1PTp15UPZRST+WbqmGzsJeMXic= MIME-Version: 1.0 Received: by 10.204.140.139 with SMTP id i11mr813961bku.316.1315628707214; Fri, 09 Sep 2011 21:25:07 -0700 (PDT) Received: by 10.204.40.15 with HTTP; Fri, 9 Sep 2011 21:25:07 -0700 (PDT) In-Reply-To: <9F15274DDC89C24387BE933E68BE3FD30D552D@MISOUT7MSGUSR9D.ITServices.sbc.com> References: <6B3493ABEE194842A8EFC3FC3B23DE6A277ED5AD74@MSXMBCCR2.roswellpark.org> <6B3493ABEE194842A8EFC3FC3B23DE6A277ED5ADB1@MSXMBCCR2.roswellpark.org> <9F15274DDC89C24387BE933E68BE3FD30D2826@MISOUT7MSGUSR9D.ITServices.sbc.com> <8375C7FDC01FEB40A11B49DD940A96AB6DCB12@HKMGAXMB110A.zone1.scb.net> <9F15274DDC89C24387BE933E68BE3FD30D33E5@MISOUT7MSGUSR9D.ITServices.sbc.com> <6AFC12B9BFCDEA45B7274C534738067F789F1777@AAPQMAILBX02V.proque.st> <4E67D265.7080806@gmail.com> <9F15274DDC89C24387BE933E68BE3FD30D552D@MISOUT7MSGUSR9D.ITServices.sbc.com> Date: Sat, 10 Sep 2011 12:25:07 +0800 Message-ID: Subject: Re: AWR reports question From: Hemant K Chitale To: JC1706@att.com Cc: "oracle-l@freelists.org" Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 38690 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hemantkchitale@gmail.com Precedence: normal Reply-To: hemantkchitale@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 No, "block changes" does not include redo. The volume of redo is identified from 'redo size' and 'redo writes'. "block changes" is only about database block changes -- the number of block changes. Of course, an update to a database block also generates redo -- but the volume of redo is better identified by 'redo size' which is in bytes. Hemant K Chitale On Sat, Sep 10, 2011 at 6:01 AM, CRISLER, JON A wrote: > Given the following snippit from a 11gR1 db, the line "Block changes"- does > that include redo as well ? > > > Cache Sizes Begin End > ~~~~~~~~~~~ ---------- ---------- > Buffer Cache: 126,976M 126,976M Std Block Size: > 8K > Shared Pool Size: 23,040M 23,040M Log Buffer: > 138,300K > > Load Profile Per Second Per Transaction Per Exec Per > Call > ~~~~~~~~~~~~ --------------- --------------- ---------- > ---------- > DB Time(s): 9.1 0.4 0.01 > 0.00 > DB CPU(s): 0.7 0.0 0.00 > 0.00 > Redo size: 294,701.7 13,914.8 > Logical reads: 43,820.4 2,069.1 > * Block changes: 1,829.8 86.4 > Physical reads: 46.2 2.2 > Physical writes: 114.7 5.4 > User calls: 2,585.1 122.1 > Parses: 519.3 24.5 > Hard parses: 13.8 0.7 > W/A MB processed: 25,411,313.0 1,199,836.5 > Logons: 1.1 0.1 > Executes: 1,627.6 76.9 > Rollbacks: 1.8 0.1 > Transactions: 21.2 > -- > http://www.freelists.org/webpage/oracle-l > > > -- http://www.freelists.org/webpage/oracle-l