ORA-00054:资源繁忙，并使用指定的NOWAIT或超时的AWSBIS308I作业结束获取

Question

我执行了一个包含Oracle过程的脚本，但是我收到了以下错误消息：

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired AWSBIS308I End of job

以下是生成错误的过程部分：

EXECUTE IMMEDIATE 'alter session set workarea_size_policy=manual';
EXECUTE IMMEDIATE 'alter session set hash_area_size=262144000';
EXECUTE IMMEDIATE 'alter session set sort_area_size=209715200';
EXECUTE IMMEDIATE 'alter session set nls_date_format = ''DD/MM/YYYY'' ';
EXECUTE IMMEDIATE 'alter session set nls_numeric_characters = ''.,'' ';
EXECUTE IMMEDIATE 'alter session enable commit in procedure';

Answer 1

当您在同一表上同时运行两个修改查询时，会导致此错误。见链接副本。