Abdul, Definately there will be performance impact upon activating the following: DB_BLOCK_CHECKING =TRUE _DB_BLOCK_CACHE_PROTECT =TRUE Is this behaviour only from last two months? If so, was there any change in the hardware or application wise? Since, you are in 9i, and don't the this problem again and again, think of Manual Rollback segment until support comes with valid response. On 2/13/07, A Ebadi <ebadi01@xxxxxxxxx> wrote:
Our production database (Oracle 9.2.0.4.0 on Solaris 10) has crashed 6-7 times in the last two months due to error below. The file involved is always a file in the Undo tablespace. Corrupt block relative dba: 0x37039d6e (file 7381, block 236910) Bad check value found during preparing block for write Data in bad block - type: 2 format: 2 rdba: 0x37039d6e last change scn: 0x0533.57fb9135 seq: 0x2 flg: 0x04 consistency value in tail: 0x91350202 check value in block header: 0x0, computed block checksum: 0xa5fd spare1: 0x0, spare2: 0x0, spare3: 0x0 *** Tue Feb 13 11:55:59 2007 Errors in file /d1000/app/oracle/admin/dwprod/bdump/dwprod_dbw2_9274.trc: ORA-00600: internal error code, arguments: [kcbzpb_1], [922983790], [3], [1], [] , [], [], [] We have an SR open with Oracle and their recommendation is to enable a couple of init parameters, but when we did that the performance overhead was unacceptable (db 2-3X slower). These parameters are: DB_BLOCK_CHECKING =TRUE _DB_BLOCK_CACHE_PROTECT =TRUE The other suggestion is to have the SA do a "low-level" memory diagnostics to check for memory problems. We have this scheduled in a few days. Has anyone encountered this before or has any suggestions? Thanks, Abdul ------------------------------ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel<http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--%0A>to find your fit.
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."