Re: Questions about ORA-600
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: jprem@xxxxxxxxxxx
- Date: Fri, 30 Jan 2015 13:43:37 +1100
Hi
I am assuming that oracle has supplied the "solution" by analysing the logs
send to them.
If that is the case, than the monitoring of the system is for 2 purposes.
1. See if the bug is fixed (one week may not be enough as previously
pointed out)
2. Test that the application still works as before and a week should be
plenty to test that.
purpose 2 is more important than 1 in my opinion as the proposed solution
has a very high probability of succes
Jack
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
On Wed, Jan 28, 2015 at 7:37 PM, Prem J <jprem@xxxxxxxxxxx> wrote:
> 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:
