Details
-
Type:
Problem report
-
Status: READY TO DEVELOP
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 5.0.8, 5.2.4, 5.4.0alpha1, 5.4 (plan)
-
Fix Version/s: 5.0.13rc1, 5.4.2rc1, 6.0.0alpha1 (master), 6.0 (plan)
-
Component/s: Agent (G)
-
Team:Team INT
-
Sprint:Sprint 74 (Mar 2021), Sprint 75 (Apr 2021), Sprint 76 (May 2021), Sprint 77 (Jun 2021)
-
Story Points: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.