New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


OracleTablespace Beta-query error Die angebene Umwandlung ist ungültig

Votes:

0

Your Vote:

Up

Down

Hi,

we have Version 16.3.24.4980 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;

oracle oracle-tablespace-sensor sql

Created on Feb 15, 2017 2:19:27 PM by  networker-KM (0) 1



Best Answer

Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hi there,

Please shorten the "Free %" columns value to only 2 values after the comma (10,22% instead of 10,2321423424...%).

Does that work?

Best regards.

Created on Feb 16, 2017 2:24:21 PM by  Dariusz Gorka [Paessler Support]



5 Replies

Votes:

0

Your Vote:

Up

Down

Hi there,

Please execute the query within your SQL-DBMS and forward us the output of it.

Best regards.

Created on Feb 16, 2017 2:10:22 PM by  Dariusz Gorka [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Thats the output from oracle developer:

http://oi64.tinypic.com/348rga0.jpg

The where statement shortens this one of one row down. Otherwise i had 10 with complete different spaces. (for example 40 MB)

Created on Feb 16, 2017 2:20:29 PM by  networker-KM (0) 1



Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hi there,

Please shorten the "Free %" columns value to only 2 values after the comma (10,22% instead of 10,2321423424...%).

Does that work?

Best regards.

Created on Feb 16, 2017 2:24:21 PM by  Dariusz Gorka [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Yes. It works now. The result is 1:1 like in sql developer now.

So The old SQL oracle-V2 sensor dont like too long digits i suppose.

Thank you

Created on Feb 17, 2017 1:00:33 PM by  networker-KM (0) 1



Votes:

0

Your Vote:

Up

Down

Oh i thought i replied already. It worked btw.! The long comma value was the problem.

Created on Feb 22, 2017 10:50:19 AM by  networker-KM (0) 1



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.