Report / notify on subvars with long running queries

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

If subvars are taking "x" amount of time to return the sql, is there any way to report/notify on the same?

Environment

CA Automic Applications Manager

9.4x, 9.5x

Resolution

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.