如果提交请求以后,状态一直是pending状态,可以在“工具”打开“Manager”,查看一下Maximum是否有设置错,另外pending的数量当前是多少。
如果Maximum是1,pending是18,则在排队的状态,需要等待前面的request执行完。或者请DBA帮忙处理。
也可以进入System administrator职责,找到Concurrent->Manager->Administer,找到pending的那个request, 点击“request”按钮查看明细。
点击“Diagnostics”查看log,一般会有说明正在等待哪个request。如:
This request may have to wait on one or more of the following requests to complete before it can begin execution:
29732300 - This request is incompatible with request 29734982.
29734427 - This request is incompatible with request 29734982.
29734427 - This request is incompatible with request 29734982.