Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-21957

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

    XMLWordPrintable

Details

    • Problem report
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 6.0.10
    • None
    • Templates (T)
    • Redhat Linux, Oracle 19

    Description

      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 

      Attachments

        Activity

          People

            zit Zabbix Integration Team
            Yayoarda Ilario
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: