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

wgkwvl · 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 · 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.