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.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center