we have Version 184.108.40.20680 of PRTG (we cannot upgrade right now because one Server is 2003 in the network with monitored scheduled tasks) and i tested the oracle-tablespace sensor in beta status. Which works fine exept the free space is on every tablespace almost the same. (this cannot be correct bcs it shows us around 32GB Space on every tablespace which is wrong!)
To compare the values we have a oracle Database 11g and our Server contractor gave us a query which sums up different values of tablespace together, to see the same stuff like free space, used MB, Total MB. I've tested it with one tablespace to be sure.
Unfortunatly we get always: "Die angebende Umwandlung ist ungültig"
the query looks like this:
SELECT a.tablespace_name tablespace, ROUND(SUM(a.total1)/1024/1024, 1) "Total Mb", ROUND(SUM(a.total1)/1024/1024, 1)-ROUND(SUM(a.sum1)/1024/1024, 1) "Used Mb", ROUND(SUM(a.sum1)/1024/1024, 1) "Free Mb", ROUND(SUM(a.sum1)/1024/1024,1)*100/ROUND(SUM(a.total1)/1024/1024,1) "Free %", ROUND(SUM(a.maxb)/1024/1024, 1) "Largest Segment Size Mb" FROM (SELECT tablespace_name, 0 total1, SUM(bytes) sum1, MAX(bytes) maxb, COUNT(bytes) cnt FROM dba_free_space GROUP BY tablespace_name UNION SELECT tablespace_name, SUM(bytes) total1, 0, 0, 0 FROM dba_data_files GROUP BY tablespace_name) a where tablespace_name= 'COMPANYNAME_DATA_INDEX' GROUP BY a.tablespace_name;