Re: Webserver connection pooling and sql trace

Hi Ryan

I'm *sure* that others including Cary would disagree, but I don't think there is any good free solution for this type of problem other than to establish a test connection (say for a specific testing end user) that uses a dedicated connection. Essentially you would need to track the application session across multiple trace files and reassemble the files into a single source representing the application session this process would seem to be prone to error. It is possible that tools like the hotsos profiler will do this sort of thing for you.

If you do use a dedicated session for testing it is also important to check that it has the same performance profile as the pooled connections.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
news:1efdad5b.0312230513.22214246_at_posting.google.com...


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