Queue Monitor dies, how to monitor
We had recent production issue where DB was not shutdown properly, hence none of the queue processes were spawned which resulted lots of WF related issues on Oracle Applications.
We also observe that the queue monitor/processes dies intermittently when DB is up & running
Although, this is due shutdown issue, i wonder whether we have any monitoring scripts /methods available to check frequently whether queue proesses/monitors are up & running?
This would help us to schedule regular alert to get notified proactively when queue processes dies or does not startup during DB startup.
Thanks in advance