Database Query Monitor Oracle database
Hello
I am trying to add a database query monitor that will check the status of the triggers of the database and sends a critical alert when any of them is disabled.
The query I am running is
select status from dba_triggers where OWNER not like '%SYS%' and STATUS='DISABLED'
I have set "status" as a primary key, though I do not know how I can set an alarm when status is disabled.
Could you kindly let me know how I could possibly define such a metric?
Thank you.
St.
I am trying to add a database query monitor that will check the status of the triggers of the database and sends a critical alert when any of them is disabled.
The query I am running is
select status from dba_triggers where OWNER not like '%SYS%' and STATUS='DISABLED'
I have set "status" as a primary key, though I do not know how I can set an alarm when status is disabled.
Could you kindly let me know how I could possibly define such a metric?
Thank you.
St.
Topic Participants
Efstathios Baroutsos
Gobi
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?