Search This Blog

Tuesday, August 2, 2011

How to FIND LONG RUNNING CONCURRENT REQUEST

With the below query you can find the LONG RUNNING CONCURRENT REQUEST
Example: the below query return all the concurrent request list which is running more than 1 hours...

SELECT request_id, actual_start_date, TRUNC((SYSDATE - actual_start_date) * 24, 1) "time in hours" 
FROM fnd_concurrent_requests 
WHERE actual_start_date LIKE SYSDATE 
AND (SYSDATE - actual_start_date) * 24 > 1
AND status_code ='R'
AND phase_code ='R';


1 comment:

Anonymous said...

An interesting discussion is worth comment. There's no doubt that that you should write more about this subject matter, it might not be a taboo matter but generally people do not speak about such subjects. To the next! Kind regards!!

Feel free to visit my page ... her explanation