If subvars are taking "x" amount of time to return the sql, is there any way to report/notify on the same?
CA Automic Applications Manager
As verified with our R&D team:
At this time There is no out of the box automated functionality to notify/ report If subvars are taking "x" amount of time to return the sql.
Please log an Idea/enhancement on our communities at community.broadcom.com or engage our professional services engagement (might be extra cost) to explore the possibility of customizations if any.
Long running queries are usually analyzed and tuned by DBA. Please work with your DBA on analyzing the same.