Details
-
Problem report
-
Status: READY TO DEVELOP
-
Major
-
Resolution: Unresolved
-
5.0.8, 5.2.4, 5.4.0alpha1, 5.4 (plan)
-
Team INT
-
Sprint 74 (Mar 2021), Sprint 75 (Apr 2021), Sprint 76 (May 2021), Sprint 77 (Jun 2021), Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021)
-
0.25
Description
Currently the metric used_pct_max for the tablespaces in the Zabbix Agent 2 Oracle plugin returns the allocated and not the used percentage of the tablespace. Please change the sql statement to something like this:
old: ROUND(DECODE(SUM(df.MAX_BYTES), 0, 0, (SUM(df.BYTES) / SUM(df.MAX_BYTES) * 100)), 2) AS USED_PCT_MAX,
new: ROUND(DECODE(SUM(df.MAX_BYTES), 0, 0, (SUM(df.BYTES)-SUM(f.FREE)) / SUM(df.MAX_BYTES)* 100), 2) AS USED_PCT_MAX,
With this change you will get the same values as in dba_tablespace_usage_metrics.