What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

High execution time oracle sql v2 sensor

Votes:

0

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



4 Replies

Accepted Answer

Votes:

1

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

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



Votes:

0

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

Stephan Linke thanks it's work .

Created on Feb 20, 2019 10:10:30 AM




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.