Alert for certain DDL/DML queries at real time using VP, TASM or any other means?
Is there a way I can send alerts using VP, TASM or any other means only for collect stats queries? My intension is to set up an alert for long running collect stats during business hours (eg: more than 15 mins).
DBQL table gets populated only on completion of the query. I couldn’t find a way to relate the data in dbc.sessioninfo table specific to collect stats query. DBC.events log the activities related to HUT utilities.
Can you please share your thoughts/suggestions on how to set up an alert for the above requirements?