Using dbMonitor

To extend monitoring capabilities of dotConnect for Oracle applications there is an additional tool called dbMonitor. It is easy-to-use tool to provide visual monitoring of your database applications.

dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.

dbMonitor has following features:

  • multiple client processes tracing;
  • SQL event filtering (by sender objects);
  • SQL parameter and error tracing.

During monitoring you can easy switch between client processes and view hierarchy of objects being traced.

dbMonitor is intended to hamper application being monitored as little as possible.

To trace your application with dbMonitor you should follow these steps:

  • Create an instance of OracleMonitor component in your application. You can do it by dropping OracleMonitor on form from toolbox or by creating it manually in code. Only one instance of OracleMonitor is needed in the application.
  • Set OracleMonitor.IsActive property to true to enable monitoring.
  • Start dbMonitor application before running your program. If dbMonitor is installed you can start it from OracleMonitor component designer by clicking "Run dbMonitor" verb or from Tools | Oracle menu.

Monitoring capabilities are accessible at design-time as well.

Using dbMonitor with ASP.NET projects

To trace your ASP.NET applications you must perform some additional steps. As ASP.NET application by default is started under ASP.NET Windows account it can not share information that dbMonitor uses with the account where dbMonitor is running. Therefore you need to follow the next steps:

  • Start ASP.NET with the same Windows account where dbMonitor runs.
  • Open machine.config file from WindowsDir\Microsoft.NET\Framework\vX.X\config\machine.config.
  • Find <processModel> tag.
  • Change userName attribute value to your Windows account name and password to your account password.
  • Setup ASP.NET service in order that it has access to current user Desktop services. To do it open Service Control Manager and find IIS Admin service. Open its properties dialog. Go to Log On tab and check 'Allow service to interact with desktop' checkbox.
  • Restart IIS.

Note: dbMonitor utility is available with dotConnect for Oracle Professional and Trial editions only.