High execution time oracle sql v2 sensor

After upgrading to 18.4.45.1898, the runtime for a SQL query for Oracle has increased . how to fix this ?

increase run-time sql-v2

Created on Feb 12, 2019 1:50:19 PM by Samir MIkayilov (0) ●1

4 Replies

Accepted Answer

Votes:

1

Your Vote:

Please check if the following version works with the expected performance: http://download3.paessler.com/beta/SQL/SQLV2_Oracle_newer_lib.zip

Place these files in C:\Program Files (x86)\PRTG Network Monitor\Sensor System and restart the PRTG Core Server service.

PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Feb 13, 2019 11:19:12 AM by Stephan Linke [Paessler Support]

Last change on Feb 13, 2019 11:19:21 AM by Stephan Linke [Paessler Support]

Votes:

0

Your Vote:

this is great.

created backup of the default ones, replaced with this on all probes and the query time went from 2000 msec to 70msec!

Great work again, maybe included in the stable release as default I will test it with about 150 oracle sensors

another sideeffect was the remote probe cpu reduction. in my case abount 40% on my oracle Probe System with 2 cores.

Regards

Created on Feb 19, 2019 6:41:17 PM by Michele Jetz (149) ●1

Votes:

0

Your Vote:

Hi Michele,

Glad it did the trick! :) It'll be included in 19.x.49. So keep it in your download folder for the time being.

PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Feb 20, 2019 7:25:00 AM by Stephan Linke [Paessler Support]

Last change on Feb 20, 2019 7:25:38 AM by Stephan Linke [Paessler Support]

Votes:

0

Your Vote:

Stephan Linke thanks it's work .

Created on Feb 20, 2019 10:10:30 AM by Samir MIkayilov (0) ●1