Enterprise Manager Generic (MOSC)

MOSC Banner

How to create an alert for a query which fetch multiple rows and columns using metric extension 13C

edited Feb 22, 2023 4:12PM in Enterprise Manager Generic (MOSC) 2 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center