Monitor Database + Oracle

XMLWordPrintable

    • Type: Incident report
    • Resolution: Duplicate
    • Priority: Major
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      I have Zabbix 3.2
      When I'm trying to get data from Oracle, instead of integers get unreadable characters
      X?P?U  `?`?`a X?

      select ceil(sum(df.BYTES)/1024/1024/1024) msize from dba_data_files df, dba_tablespaces ts where df.tablespace_name=ts.tablespace_name and ts.tablespace_name='SYSTEM' group by ts.tablespace_name

      But through isql -in all good

      SQL> select ceil(sum(df.BYTES)/1024/1024/1024) msize from dba_data_files df, dba_tablespaces ts where df.tablespace_name=ts.tablespace_name and ts.tablespace_name='SYSTEM' group by ts.tablespace_name
      +-----------------------------------------+
      | MSIZE                                   |
      +-----------------------------------------+
      | 12                                      |
      +-----------------------------------------+
      SQLRowCount returns -1
      1 rows fetched
      

            Assignee:
            Unassigned
            Reporter:
            Marvin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: