Return-Path: Received: from mail.sagelogix.com by ocs.sagelogix.com with ESMTP id 3528011086961307; Fri, 11 Jun 2004 07:41:47 -0600 Received: by mail.sagelogix.com (Postfix, from userid 16) id 763D2A8193; Fri, 11 Jun 2004 08:54:34 -0600 (MDT) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by mail.sagelogix.com (Postfix) with ESMTP id C97BDA818C for ; Fri, 11 Jun 2004 08:54:31 -0600 (MDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 669A972CA8F; Fri, 11 Jun 2004 09:36:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32370-86; Fri, 11 Jun 2004 09:36:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA51772C7D4; Fri, 11 Jun 2004 09:36:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 11 Jun 2004 09:35:08 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5464972C8AD for ; Fri, 11 Jun 2004 09:35:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32392-42 for ; Fri, 11 Jun 2004 09:35:08 -0500 (EST) Received: from web42003.mail.yahoo.com (web42003.mail.yahoo.com [66.218.93.171]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 87C9D72CA55 for ; Fri, 11 Jun 2004 09:35:07 -0500 (EST) Message-ID: <20040611145447.60938.qmail@web42003.mail.yahoo.com> Received: from [68.36.142.134] by web42003.mail.yahoo.com via HTTP; Fri, 11 Jun 2004 07:54:47 PDT Date: Fri, 11 Jun 2004 07:54:47 -0700 (PDT) From: "M.Godlewski" Subject: check sum init.ora To: oracle-l@freelists.org In-Reply-To: <015a01c44f59$3746b180$6701a8c0@CVMLAP02> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-750877748-1086965687=:41475" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2560 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mcgodlewski@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Status: No, hits=0.0 required=3.0 tests=HTML_MESSAGE autolearn=no version=2.63 X-Spam-Level: --0-750877748-1086965687=:41475 Content-Type: text/plain; charset=us-ascii I'm looking into enabling the db_block_checksum parameter. I've searched through the archives, but haven't seen any indication if there is a significant overhead on performance when running with this parameter enabled. The Oracle dba guide has a note: "There is some overhead and decrease in database performace with DB_BLOCK_CHECKSUM enabled. Monitor your database performance to decide if the benefit of using data block checksums to detect corruption outweights the performace impact." Does anyone currently run with checksum turned on? What performance impact have you noticed? --------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --0-750877748-1086965687=:41475 Content-Type: text/html; charset=us-ascii
I'm looking into enabling the db_block_checksum parameter.  I've searched through the archives, but haven't seen any indication if there is a significant overhead on performance when running with this parameter enabled. 
 
The Oracle dba guide has a note: "There is some overhead and decrease in database performace with DB_BLOCK_CHECKSUM enabled.  Monitor your database performance to decide if the benefit of using data block checksums to detect corruption outweights the performace impact."
 
Does anyone currently run with checksum turned on?  What performance impact have you noticed?

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger --0-750877748-1086965687=:41475-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------