取消请求的sql语句

来源：老王  网络

在日常维护中，我们会经常发现，有些请求无法取消，而且占用资源很高。这时候就需要我们从后台用sql语句修改这个请求的状态。
update fnd_concurrent_requests set status_code='X',phase_code='C' where request_id=;

Subject:  How to Cancel a Concurrent Request Stuck in the Queue? 
Doc ID:  749748.1 Type:  PROBLEM 
Modified Date :  02-MAR-2009 Status:  MODERATED

In this Document
  Symptoms
  Cause
  Solution
  References
 --------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

 

Applies to:
Oracle Application Object Library - Version: 11.0 to 12.0
This problem can occur on any platform.
11.0.x - 12.0.x
Symptoms
Unable to cancel a concurrent request out of the queue that is stuck.

Cause
Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form.

Got the following message:

Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.

 

Solution
Manually cancel the request out of the queue with the following SQL against the offending
request id(s). This can be safely done while managers are up and running:

SQL> UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE request_id = '';
commit;

Note:  To obtain request details prior to cancelling the request, use Note 134035.1 ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request. When prompted, provide the request id to be analyzed.  This can be useful for determining the reason why the request may be stuck in the queue.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15187685/viewspace-764990/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15187685/viewspace-764990/