Oracle Database Sensor better connection management
Modified on 2025-06-10 20:13:59 +0200
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
Important: We no longer maintain this article. The information might be out of date.
Every time you attach to a database there is load on the probe and the database which is a problem when you have hundreds of databases each with 10-15 sensors.
I would like to see PRTG open one connection to the database and run the sql for all sensors under the database device. This would dramatically reduce CPU on the probe and hits on the database.
Even better yet would be an option that allows you to have a pooled connection that allows prtg to use the same open connection to query the database and re-open it if it is closed.
Article Comments
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.
