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