How to send a notification email when a deadlock is encountered in alert log on any node like the deadlocks encountered below? (an alert any time a deadlock is detected in alert log)
Node 1: Mon Sep 08 16:23:59 2014 Global Enqueue Services Deadlock detected. More info in file /u01/oracle/diag/rdbms/luma/LUMA1/trace/LUMA1_lmd0_4814.trc. Node 2: Mon Sep 08 16:37:47 2014 Global Enqueue Services Deadlock detected. More info in file /u01/oracle/diag/rdbms/luma/LUMA2/trace/LUMA2_lmd0_2602.trc.
I am using DB Control (11g).