Trace events with OracleMonitor

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hansjoergp
Posts: 25
Joined: Wed 31 May 2017 14:33

Trace events with OracleMonitor

Post by hansjoergp » Tue 03 Dec 2019 15:28

Hello,
I want to trace some Events with the OracleMonitor class and the TraceEvent. Everything works fine, but the problem is, that this has an big performance impact.
I want to trace only Devart.Common.MonitorTracePoint.AfterEvent with an Error, Connect and Disconnect EventType.
It seems to me that the performance is so bad, because it tries to send the events also to the DbMonitor application at the same time. But I don't need it.
Are there other possiblities to log it

Thanks

Shalex
Site Admin
Posts: 9023
Joined: Thu 14 Aug 2008 12:44

Re: Trace events with OracleMonitor

Post by Shalex » Wed 04 Dec 2019 12:27

hansjoergp wrote:
Tue 03 Dec 2019 15:28
It seems to me that the performance is so bad, because it tries to send the events also to the DbMonitor application at the same time. But I don't need it.
Please set OracleMonitor.UseApp=false in your application. Refer to https://www.devart.com/dotconnect/oracl ... seApp.html.

hansjoergp
Posts: 25
Joined: Wed 31 May 2017 14:33

Re: Trace events with OracleMonitor

Post by hansjoergp » Wed 04 Dec 2019 12:50

Thanks. It works

hansjoergp
Posts: 25
Joined: Wed 31 May 2017 14:33

Re: Trace events with OracleMonitor

Post by hansjoergp » Wed 04 Dec 2019 14:43

I have made now tests and it seems that already when I have an instance with OracleMonitor with the following settings

Code: Select all

monitor = new OracleMonitor();
monitor.IsActive = true;
monitor.UseApp = false;
//monitor.TraceEvent += Monitor_TraceEvent;
I need double the time for the execution, if I have commented out the TraceEvent!

Shalex
Site Admin
Posts: 9023
Joined: Thu 14 Aug 2008 12:44

Re: Trace events with OracleMonitor

Post by Shalex » Mon 09 Dec 2019 20:39

If you do not handle TraceEvent, please dispose the OracleMonitor object.

We will investigate the possibility to choose events to send (instead of sending all events).

Post Reply