{"name":"Host CPU Utilisation %","description":"Reads Oracle's own Host CPU Utilization (%) system metric from V$SYSMETRIC, which is maintained continuously and is very cheap to query. GROUP_ID = 2 selects the 60-second interval metric; the MAX() aggregate and constant con_id 0 make the query portable across non-CDB, multitenant CDB, and RDS connections.","tsql":"-- Returns the latest host CPU utilisation percentage (60-second metric)\r\nSELECT 0 AS con_id, ROUND(MAX(value), 2) AS metric_value\r\n  FROM v$sysmetric\r\n WHERE metric_name = 'Host CPU Utilization (%)'\r\n   AND group_id = 2","instances":false,"instances_comment":"Reported at instance level (con_id 0)","databases":{"mode":1},"frequency":60,"frequency_comment":"seconds (collected every minute)","rateofchange":false,"metricenabled":true,"alertname":"Host CPU sustained above 90%","alertdescription":"Host CPU utilisation has stayed above 90% for 3 consecutive collections, so brief bursts (backups, batch jobs) do not alert. Investigate top CPU sessions and recent plan changes.","aboveorbelow":"above","_thresholds_high":{"selected":true,"value":90},"collections":3,"alertenabled":true,"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"targetentitytype":2}