我有这样的PL/SQL脚本。。。
DECLARE
CURSOR curs_delete
IS
SELECT cus_num
FROM dob.cust_table GROUP BY cust_num HAVING COUNT(*)>1;
TYPE row_cust_num IS TABLE OF dob.cust_table.cust_num%TYPE;
col_cust_num row_cust_num;
BEGIN
OPEN curs_delete;
LOOP
FETCH curs_delete
BULK COLLECT INTO col_cust_num LIMIT 10000;
EXIT WHEN col_cust_num.EXISTS (1) = FALSE;
FORALL i IN 1 .. col_cust_num.LAST
DELETE FROM cust_table
WHERE cust_num = col_cust_num (i);
COMMIT;
END LOOP;
CLOSE curs_delete;
END;
此查询返回ORA-12805:parallel query server died unexpectedly
错误。我不知道为什么会发生这种事。当我得到这个错误时,游标中的select查询返回了大约415条记录。
有人知道为什么会出现这个错误吗?
这是DBA需要解决的问题,因为有很多可能的原因。需要有人查看警报日志,并在bdump
目录中检查跟踪文件以获取诊断信息。
同时,如果你只有415条记录要删除,你应该直接使用SQL:
DELETE FROM cust_table
WHERE cust_num in (SELECT cus_num
FROM dob.cust_table
GROUP BY cust_num HAVING COUNT(*)>1);