How to use DbMonitor to trace SQL from specific user in SOA

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
wgkwvl
Posts: 39
Joined: Tue 20 Jul 2010 15:13

How to use DbMonitor to trace SQL from specific user in SOA

Post by wgkwvl » Tue 20 Jul 2010 15:20

We're using Entity Framework for Data access and WCF for the service layer.

Is it possible to trace the SQL only for a specific user of the service layer using dbmonitor ?


If I make an instante of OracleMonitor it will send all the database activity of everyone who is using my service layer won't it ?

Or should I use another tool for this ?

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 23 Jul 2010 13:07

Could you please describe which user activity you want to extract from the entire database activity log - User Id of your connection string, or user of your service, etc? dbMonitor receives all database activity of the application in which the OracleMonitor instance is created, and OracleMonitor.IsActive = true. There is no filter which allows to trace activity of only separate UserId in dbMonitor. But you can handle the OracleMonitor.TraceEvent event and print out your own log basing on your specific criterias:
http://www.devart.com/dotconnect/oracle ... nt_EV.html.

Post Reply