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

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

Your Vote:

Up

Down

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:

Up

Down

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:

Up

Down

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 (133) 1



Votes:

0

Your Vote:

Up

Down

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:

Up

Down

Stephan Linke thanks it's work .

Created on Feb 20, 2019 10:10:30 AM by  Samir MIkayilov (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.