We have serious problem with Oracle 10G while upgrading our Application to 10G.
If I run following or any Update statement with parallel hints, It fails with ORA-600
I do this to produce this error
ALTER SESSION ENABLE PARALLEL DML;
UPDATE /*+ PARALLEL(A,4)*/ D_USERS A SET A.LOCATION_ID= (SELECT /*+ PARALLEL(B,4) */ B.LOCATION_ID FROM C_LOCATION B
ORA-12801: error signaled in parallel query server P006
ORA-00600: internal error code, arguments: [kcbchg1_6], , , , , , , 
ORA-06512: at line 18
Oracle has identified it a bug(6057203) and has ‘nt produced a fix for the last 4 ˝ months , But I am wondering How it is possible that such a common fuctionality is broken ? Keeping in mind that there is a large custome base with a widespread use of Oracle 10G out there. So far they have’nt provided any workarounds , They ‘ve come up with a one- off patch but that also blew up parallel updates with a different error(ORA-12805). So we are lost
. It is needless to say that we have tons of update statements in our application that uses parallel hints
Any body has encountered this error.
I have this environment