Monitor pending standby and pending normal concurrent request
We are using EBS version 12.2.4
I want to write a script that monitors pending standby and pending normal concurrent request.
Say for example if pending standby and pending normal together count up to more than 30, then it will send an alert for email for us to be aware of.
I tried the below query:
select count(*) from fnd_concurrent_requests where phase_code='P' and (status_code='C' or status_code='Q');
However, I am not sure why it also accounted for all the pending scheduled one. I do not need to account for the pending scheduled concurrent request.
Gurus, please advise. Thank you.