{"name":"Internal Errors ORA-600 \/ ORA-7445 (last hour)","description":"Counts either error in the alert log within the last 60 minutes, per container. Querying V$DIAG_ALERT_EXT reads the alert log and can be heavier than a typical view query \u2014 always bound it with the originating_timestamp predicate as shown, avoid collection intervals shorter than a few minutes, and test execution time on a non-production instance first.","tsql":"-- Returns the number of ORA-00600 \/ ORA-07445 errors in the alert log\r\n-- during the last 60 minutes, per container\r\nSELECT c.con_id,\r\n       NVL(d.cnt, 0) AS metric_value,\r\n       d.detail AS alert_detail_text\r\n  FROM v$containers c\r\n  LEFT JOIN (\r\n        SELECT con_id,\r\n               COUNT(*) AS cnt,\r\n               MAX(TO_CHAR(originating_timestamp, 'HH24:MI') || ' ' || SUBSTR(message_text, 1, 200)) AS detail\r\n          FROM v$diag_alert_ext\r\n         WHERE originating_timestamp > SYSTIMESTAMP - INTERVAL '60' MINUTE\r\n           AND (message_text LIKE '%ORA-00600%' OR message_text LIKE '%ORA-07445%')\r\n         GROUP BY con_id\r\n       ) d\r\n    ON d.con_id = c.con_id\r\n WHERE c.name <> 'PDB$SEED'\r\n   AND c.open_mode <> 'MOUNTED'","instances":true,"databases":{"mode":1},"frequency":600,"frequency_comment":"seconds (collected every 10 minutes)","rateofchange":false,"metricenabled":true,"alertname":"Internal errors (ORA-600 \/ ORA-7445)","alertdescription":"ORA-00600 or ORA-07445 errors were written to the alert log for this container within the last hour. Check the alert detail text for the most recent message, review the referenced trace files, and consider raising an Oracle support request (SR). Some environments have a known, benign, recurring ORA-600 caused by an Oracle bug (identifiable by its problem key \/ My Oracle Support note) \u2014 on those instances, raise the alert threshold above the known baseline rather than disabling the alert, so an unusual volume of internal errors still alerts.","aboveorbelow":"above","_thresholds_high":{"selected":true,"value":0},"collections":1,"alertenabled":true,"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"targetentitytype":2}