How to create an alert for a query which fetch multiple rows and columns using metric extension 13C
Hi All,
I want to set below query for alerts in 13C metrics. Query is giving multiple rows and multiple columns. Please suggest if we can create a matric extension for this?
select inst_id, sid, serial#, machine, action, module, logon_time,round(last_call_et/60) idle_time_mns, status from gv$session where module like'MWAJDBC%' and last_call_et > 7200 order by idle_time_mns DESC;
Thanks,
Vijay