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 ,
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 :
- 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.
- 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-lReceived on Wed Jan 28 2015 - 09:37:40 CET