Item Prototype "oracle.tbs_used_file_pct["{#TABLESPACE}"]" in LLD "Tablespace discovery" in Template "Oracle by ODBC" calculate wrong used tablespace

XMLWordPrintable

    • Type: Problem report
    • Resolution: Fixed
    • Priority: Trivial
    • None
    • Affects Version/s: 6.0.10
    • Component/s: Templates (T)
    • Environment:
      Redhat Linux, Oracle 19

      Steps to reproduce:

      1. Configure ODBC on proxy or server to connect to Oracle Database 19
      2. Add host with correct Macro to server ODBC Template
      3. Add Template Oracle by ODBC
      4. Wait the LLD ends and check the item created from item prototype in subject

      Result:

      Item calculate with formula: Used bytes/Allocated bytes*100 , but the right formula is Used bytes/MAX size *100

      The first formula is good if you have a tablespace with single datfile created already "max extended" but in real scenario this is never true 

            Assignee:
            Kristaps Naglis
            Reporter:
            Ilario
            Votes:
            3 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: