Re: Webserver connection pooling and sql trace

rgaffuri_at_cox.net (Ryan Gaffuri) wrote

> The software engineers set up middle tier connection pooling. This
> opens several dedicated processes to the instance and pools user
> connections.
>
> how do I use sql trace with this? statspack is giving me aggregates. I
> need to see what individual users are doing. Carrie Milsap has a good
> article on hotsos.com called 'Oracle Operational Timing Data' that
> warns you to be careful of aggregate data and to use sql trace.
>
> Not sure if I can turn off connection pooling for test purposes.

Why do you want to trace users? In this configuration you are not dealing with users. The app server deals with users. You deal with applications on the app server. Trace and monitor the applications.

Client-server is a software configuration. The clients connecting to your database are applications and no longer users.

--
Billy