Trace events with OracleMonitor

[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

[Shalex]

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]

Thanks. It works

[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!

[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).

[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.