A) This query provides the concurrent requests submitted since 12AM, today
select count(*) from apps.fnd_concurrent_requests
where request_date > sysdate - (1/24*(select extract(hour from current_timestamp)+4
/*since my timezone is GST+4 */ from dual)) order by request_date ;
This can be fine tuned for count of completed requests.
B) This query provides the count of conc requests submitted in last one hour.
select count(request_date) from apps.fnd_concurrent_requests where request_date > sysdate -(1/24)
I created a job that uses this query to insert count and sysdate values into an "xyz" table on scott schema.
Later, I used this "xyz" table to create a graph (using ODBC) on MS Excel spreadsheet, that represents the Request submitting pattern of my organization.
The funny part is, the graph dives deep at coffee breaks and lunch break.
Your feedback are welcome.
Sundar K
select count(*) from apps.fnd_concurrent_requests
where request_date > sysdate - (1/24*(select extract(hour from current_timestamp)+4
/*since my timezone is GST+4 */ from dual)) order by request_date ;
This can be fine tuned for count of completed requests.
B) This query provides the count of conc requests submitted in last one hour.
select count(request_date) from apps.fnd_concurrent_requests where request_date > sysdate -(1/24)
I created a job that uses this query to insert count and sysdate values into an "xyz" table on scott schema.
Later, I used this "xyz" table to create a graph (using ODBC) on MS Excel spreadsheet, that represents the Request submitting pattern of my organization.
The funny part is, the graph dives deep at coffee breaks and lunch break.
Your feedback are welcome.
Sundar K
No comments:
Post a Comment
Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)