Remote dbMonitor

[mkrmp]

Hello,

We're using MVC.NET with dotConnect for Oracle. How do we setup/configure remote dbMonitor on our test web server running IIS. We would like to review the queries on the web server getting sent to Oracle.

Is there a guide or set of instructions? It seems like there should be a Devart.Data.Oracle.OracleMonitor component we can add and configure in our project, but we aren't seeing this as an available component.

Is there a particular component/library/extension we need to get this to work?

https://www.devart.com/dbmonitor/features.html

Thanks

[Pinturiccio]

The OracleMonitor component is available in toolbox only for Windows Forms Applications. It is not available in design-time for web applications. However, you can initialize and use an OracleMonitor object in your code. For example, add the following code:

Code: Select all

OracleMonitor mon = new OracleMonitor() { IsActive = true };

For remote monitoring you need to specify values for the Host and Port properties. For the Host property you should provide the host where dbMonitor is running. For the Port property you should set a port, which dbMonitor is listening. By default it is 1000, and if you did not change the default Port value in dbMonitor options, there is no need to configure it for OracleMonitor.

Thus, you need to use the following code:

Code: Select all

OracleMonitor mon = new OracleMonitor() { IsActive = true };
mon.Host = "host name";
mon.Port = 1000; //default value

Please also note that OracleMonitor is designed for testing purpose and it is not recommended to use OracleMonitor in the production version because it may decrease the application performance.