Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> check sum init.ora

check sum init.ora

From: M.Godlewski <mcgodlewski_at_yahoo.com>
Date: Fri, 11 Jun 2004 07:54:47 -0700 (PDT)
Message-ID: <20040611145447.60938.qmail@web42003.mail.yahoo.com>


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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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

-----------------------------------------------------------------
Received on Fri Jun 11 2004 - 09:52:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US