{"name":"Tablespace Used % \u2013 USERS","description":"Tracks the used percentage of the USERS tablespace, measured against the maximum size it can reach (autoextend-aware). Create one instance of this metric per permanent tablespace you want to monitor, substituting the tablespace name in the WHERE clause; the metric automatically returns one value per container (PDB) that has the tablespace.","tsql":"-- Returns used space as a percentage of maximum (autoextend-aware)\r\n-- Replace USERS with your target tablespace name; one row is returned per container that has it\r\nSELECT m.con_id,\r\n       ROUND(m.used_percent, 2) AS metric_value,\r\n       m.tablespace_name || ' ' || ROUND(m.used_percent, 1) || '% used' AS alert_detail_text\r\n  FROM cdb_tablespace_usage_metrics m\r\n WHERE m.tablespace_name = 'USERS'","instances":true,"databases":{"mode":1},"frequency":300,"frequency_comment":"seconds (collected every 5 minutes)","rateofchange":false,"metricenabled":true,"alertname":"Tablespace Used % \u2013 USERS","alertdescription":"The USERS tablespace is approaching the maximum size it can reach (including autoextend headroom). If it fills, Oracle raises ORA-01653\/ORA-01654 and operations that need space halt.","aboveorbelow":"above","_thresholds_high":{"selected":true,"value":90},"_thresholds_medium":{"selected":true,"value":80},"collections":1,"alertenabled":true,"_thresholds_low":{"selected":false},"targetentitytype":2}