Oracle Tablespace does not generate "DBO - Tablespace Used Percentage" alarms (4376264)

Oracle Tablespace does not generate DBO - Tablespace Used Percentage alarms, even when a Tablespace got full.

The DB_Oracle agent logs shows messages like these:

ERROR [hostname01-inst01-lowPriorityPool-17630-[DBO_TablespacesStorage][2024/06/10 22:16:16]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBODataFileProcessor processor of DBO_TablespacesStorage collection of hostname01-inst01 instance.
java.lang.RuntimeException: Failed to execute collection [DBO_TablespacesStorage], reason=ORA-01476: divisor is equal to zero

OS collections are running normally yet the Tablespaces and Datafiles dashboard shows Total Size Used % column as n/a for every Tablespace.

Selecting a Tablespace to display Datafiles, shows no data about Datafiles.

The DBODataFileProcessor processor of DBO_TablespacesStorage collection causes a division by zero when sys.CDB_TEMP_FILES.bytes is null or 0:

[...]
MAX (ROUND (((NVL (t.bytes, 0) - NVL (p.bytes_used, 0)) / NVL (t.bytes, 0)) * 100, 2)) freepercent,
[...]

This defect was identified as FOG-8910.

WORKAROUND.

Request a hotfix for FOG-8910.

STATUS.

Waiting for a fix in a future release of Foglight.