Trace Oracle commands

Dominik · Post by **Dominik** » Thu 08 Jul 2010 07:47

Hi,

Is there a trace provider for Oracle like EFTracingProvider (http://code.msdn.microsoft.com/EFProviderWrappers) is for SQL commands?

Does OracleTrace class perform something like this?

If it is, where can I find some information about how to use it?

Thanks in advance,

Dominik.

AndreyR · Post by **AndreyR** » Fri 09 Jul 2010 13:13

No, OracleTrace is not intended for Entity Framework SQL monitoring.
We have a special component for tracing - Devart DbMonitor.
You can download this component here
Description of the DbMonitor usage is available here.

Dominik · Post by **Dominik** » Fri 09 Jul 2010 13:28

Ok,

But I would like to perform tracing of SQL commands generated by devart Oracle provider from my application for deployment purposes.

May I assume then, that it cannot be possible?

Thanks,

Dominik.

AndreyR · Post by **AndreyR** » Fri 09 Jul 2010 14:11

Here is a simple code sample:

Code: Select all

...
OracleMonitor mon = new OracleMonitor;
mon.IsActive = true;
mon.TraceEvent += Devart.Common.MonitorEventHandler(mon_TraceEvent);
...
void mon_TraceEvent (object sender, Devart.Common.MonitorEventArgs e) {
      if (e.EventType == Devart.Common.MonitorEventType.Execute) {
        //add here your tracing code
      }
    }

In this case you don't need to use an external appilcation.