Giovanni, Thanks for the reply and pseudo-code. Regards, Larry G. Elkins > -----Original Message----- > Hi Larry, > I implemented your requirements while developing an application > some years ago. > Here are some implmentation details: > 1)I wrapped the connectionpool class and the calls for > getting/releasing the connections were made trough the wrapper, this > means that in the wrapper I can enable tracing while leasing the > connection and disable while releasing it. > 2)the ability to turn off/on the tracing was dictated by two factors: > the trace level of the class wrapper itself (very easy to do if you > use log4J or similar that gives automatically the trace level for the > class) and an optional parameter passed to wrapper while leasing the > connection. ...... ...... > > Hope it helps, > Giovanni -- //www.freelists.org/webpage/oracle-l