Metric and threshold regex parsing
For example, one of the defaults is to include only ORA-0600, 7445, and 4xxx in generic alert log errors with the following regex:
Generic Alert LOG Error MATCHES warning=“ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]” critical=””
If the regex parser supports look-ahead then the following would filter out 600 and 7445 from critical alerts, when entered into the critical field:
Generic Alert LOG Error MATCHES warning=“ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]” critical=”^(?!.*?(600|7445)).+$”
I know that 10g there is the Alert Log Filter which works just fine, but with 11g db the recommendation is to set the “set_agent_property” verb (bulletin id 949858.1). Which is combersome compared to using a simple regex if possible.