Hi All,

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
WHERE A.USER_ID=B.USER_ID);
COMMIT;

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
Oracle 10.2.0.3
Windows 2000
Thanks
BzDBA