Connection pool logging to log4net

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Amod
Posts: 3
Joined: Thu 16 May 2019 09:59

Connection pool logging to log4net

Post by Amod » Thu 16 May 2019 11:07

Hi

I would like to log the connection pool activity and time to establish a connection into a log file for my application. I can do it using dbMonitor but I would like to do it from within my application by enabling logging of the same. Is there a way I can have it working with my log4net configuration.

Thanks

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Connection pool logging to log4net

Post by Shalex » Fri 17 May 2019 14:13

1. Please create the OracleMonitor instance, set its UseApp property to false, send the required information to log4net via the TraceEvent handler: https://www.devart.com/dotconnect/oracl ... nt_EV.html.

2. Set "Use Performance Monitor=true;" in your connection string to activate performance counters: https://www.devart.com/dotconnect/oracl ... nters.html.

Post Reply