Page 1 of 1
Trace events with OracleMonitor
Posted: Tue 03 Dec 2019 15:28
by hansjoergp
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
Re: Trace events with OracleMonitor
Posted: Wed 04 Dec 2019 12:27
by Shalex
hansjoergp wrote: ↑Tue 03 Dec 2019 15:28It 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.
Re: Trace events with OracleMonitor
Posted: Wed 04 Dec 2019 12:50
by hansjoergp
Thanks. It works
Re: Trace events with OracleMonitor
Posted: Wed 04 Dec 2019 14:43
by hansjoergp
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!
Re: Trace events with OracleMonitor
Posted: Mon 09 Dec 2019 20:39
by Shalex
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).
Re: Trace events with OracleMonitor
Posted: Mon 21 Sep 2020 16:29
by Shalex
dotConnect for Oracle v9.13.1098 includes improvements:
* The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
* The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
Refer to
viewtopic.php?f=1&t=42246.