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

Article Comments

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


Feb, 2019 - Permalink

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


Feb, 2019 - Permalink

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


Feb, 2019 - Permalink

Stephan Linke thanks it's work .


Feb, 2019 - Permalink