{"name":"Tablespace Used % (worst per container)","description":"Tracks the highest used percentage among permanent tablespaces in each container, measured against the maximum size each tablespace can reach (autoextend-aware). One metric covers every permanent tablespace in every PDB and raises a separate alert per container; the alert detail text lists all permanent tablespaces with their used percentages, worst first. UNDO and TEMP are excluded (undo idles low but can spike under load and would otherwise dominate the MAX; temp has its own metric).","tsql":"-- Returns the worst permanent-tablespace used % per container (autoextend-aware),\r\n-- with all permanent tablespaces listed in the alert detail text\r\nSELECT m.con_id,\r\n       ROUND(MAX(m.used_percent), 2) AS metric_value,\r\n       LISTAGG(m.tablespace_name || ' ' || ROUND(m.used_percent, 1) || '%', ', ' ON OVERFLOW TRUNCATE)\r\n           WITHIN GROUP (ORDER BY m.used_percent DESC) AS alert_detail_text\r\n  FROM cdb_tablespace_usage_metrics m\r\n  JOIN cdb_tablespaces ts\r\n    ON ts.con_id = m.con_id\r\n   AND ts.tablespace_name = m.tablespace_name\r\n WHERE ts.contents = 'PERMANENT'\r\n GROUP BY m.con_id","instances":true,"databases":{"mode":1},"frequency":300,"frequency_comment":"seconds (collected every 5 minutes)","rateofchange":false,"metricenabled":true,"alertname":"Tablespace running out of space (worst per container)","alertdescription":"A permanent tablespace in this container is approaching the maximum size it can reach (including autoextend headroom). The alert detail text lists all permanent tablespaces with their used percentages, worst first.","aboveorbelow":"above","_thresholds_high":{"selected":true,"value":90},"_thresholds_medium":{"selected":true,"value":80},"collections":1,"alertenabled":true,"_thresholds_low":{"selected":false},"targetentitytype":2}