Summary
Using Oracle10g with HP-UX Itanium when trying a parallel update you might get the error
ORA-12801: error signaled in parallel query server P077
ORA-00600: internal error code, arguments: [kghstack_free1], [kdu_clone_kduu:kduu[kd]col], [], []
For example the following statement will generate ORA-00600
update /*+ PARALLEL(TT,16) */ CUSTOMER_VIEW.CUSTOMER_VIEW_FCT TT
set TOTAL_ACCOUNTS_REG=TOTAL_ACT_ACCOUNTS-(TOTAL_ACCOUNTS_DUN+TOTAL_ACCOUNTS_TEAM);
Workaround
1. Either
do the update without the parallel hint
or
2.
recreate the table with
CTAS. First create a new table X with CTAS, rename the old table to Y and rename the X to old table name, after that you can do the parallel update.