Saturday, August 6, 2011

Total Concurrent Requests ran yesterday


Total Concurrent Requests ran yesterday :

SELECT sysdate -1, COUNT(*)
FROM apps.fnd_concurrent_requests
WHERE to_char(actual_completion_date,'YYYYMMDD') =
(SELECT to_char(sysdate -1,'YYYYMMDD') FROM dual);

SYSDATE-1                 COUNT(*)            
------------------------- ----------------------
04-AUG-11                 50305                

1 rows selected

UR's Key Run ;-) 

No comments:

Post a Comment