WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK

显示全部楼层 · 2005-10-30 17:05:33

同时执行多个sqlload进行数据加载时报错：
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK
各位前辈该如何处理

千问 · 2005-10-30 17:05:33

千问 · 2005-10-30 17:05:33

谢谢！

千问 · 2005-10-30 17:05:33

千问 · 2005-10-30 17:05:33

还是串行执行吧.

千问 · 2005-10-30 17:05:33

Check the number of locks in v$lock, and what kind of locks they are.
The "Waiting for Enqueue" message occurs during a Batch job.
Serialize the batch stream as much as possible to reduce contention.

千问 · 2005-10-30 17:05:33

select sid,event,wait_time,SECONDS_IN_WAIT from v$session_wait;
SID EVENT
WAIT_TIME SECONDS_IN_WAIT
---------- ---------------------------------------- ---------- ---------------
1 pmon timer
0 59227
2 rdbms ipc message
0
876
3 rdbms ipc message
0
74
4 rdbms ipc message
0
74
5 rdbms ipc message
0
3693
6 rdbms ipc message
0
1701
11 rdbms ipc message
0 51787
7 rdbms ipc message
0
876
8 rdbms ipc message
0
411
9 rdbms ipc message
0
0
13 enqueue
0 53344
40 enqueue
0 53832
20 enqueue
0 53257
48 enqueue
0 53801
10 smon timer
0 15929
24 row cache lock
0 53832
18 SQL*Net message to client
-2
0
15 SQL*Net message from client
0 53833
19 SQL*Net message from client
0
23
51 SQL*Net message from client
0 53833
42 SQL*Net message from client
0 53876
21 SQL*Net message from client
0
613
22 SQL*Net message from client
0 55383
16 SQL*Net message from client
0 53833
25 PX Deq Credit: send blkd
0
0
29 PX Deq Credit: send blkd
0
0
30 PX Deq Credit: send blkd
0
0
28 PX Deq Credit: send blkd
0
0
35 PX Deq Credit: send blkd
0
0
37 PX Deq Credit: send blkd
0
0
36 PX Deq Credit: send blkd
0
0
27 PX Deq Credit: send blkd
0
0
23 PX Deq: Execution Msg
0
0
26 PX Deq: Execution Msg
0
0
49 PX Deq: Execution Msg
0
0
45 PX Deq: Execution Msg
0
3
31 PX Deq: Execution Msg
0
0
32 PX Deq: Execution Msg
0
0
33 PX Deq: Execution Msg
0
3
34 PX Deq: Execution Msg
0
3
已选择40行。
dml_locks=2048,enqueue_resources=3072,是不是还有点小？
斑竹：您说的串行执行是指什么？谢谢！