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

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

Postby 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 ?
wgkwvl
 
Posts: 39
Joined: Tue 20 Jul 2010 15:13

Postby 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/docs/?Devart.Data~Devart.Common.DbMonitor~TraceEvent_EV.html.
Shalex
Devart Team
 
Posts: 7703
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle