Questions about ORA-600

From: Prem J <jprem_at_outlook.com>
Date: Wed, 28 Jan 2015 14:07:40 +0530
Message-ID: <BLU169-W356A51359B760E9801D8DDBC330_at_phx.gbl>



Friends ,

Got below ORA-600 on one of our customer's 10.2.0.3 (sparc) box .

ORA-600 [KCBGET_37] / ORA-600 [1100] AND INSTANCE CRASH (not reproducible at will . and this bug is related to some buffer cache corruption)

So we suggested to apply patch 6110331 - and to monitor the instance for a week .

Questions from user :

  1. User : what's the frequency at which ora-600 error occurs ? Me : ora-600 is mostly due to bugs and can't really say when it will pop up . there is so clear cut way to say when it will happen again.
  2. user : when you ora-600 are rare and happens at random - on what basis do you 1 week of monitoring the instance (after patch) will suffice ? me : usually - 1 week is the minimum time you monitor the instance - ensure that you test all your important business processes and if all goes thro' fine and if ora-600 does not happen again . then you should be safe .

What would have been your reply for the above 2 questions ? I am looking for stronger/deeper points about ORA-600 occurrence and how it should be tested (after patch) . Would like to rephrase my next (to user) reply more technically & politically correct.

Regards,
JP                                                

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 28 2015 - 09:37:40 CET

Original text of this message