[ZBX-11293] Monitor Database + Oracle Created: 2016 Sep 30 Updated: 2017 May 30 Resolved: 2016 Sep 30 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | None |
Type: | Incident report | Priority: | Major |
Reporter: | Marvin | Assignee: | Unassigned |
Resolution: | Duplicate | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
I have Zabbix 3.2 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 |
Comments |
Comment by Glebs Ivanovskis (Inactive) [ 2016 Sep 30 ] |
Closing as duplicate of |
Comment by Marvin [ 2016 Sep 30 ] |
thank you so much |