Questions about ORA-600
- From: Prem J <jprem@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2015 14:07:40 +0530
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
Other related posts:
