Re: Webserver connection pooling and sql trace

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Tue, 23 Dec 2003 12:21:04 -0500
Message-ID: <bs9ti0$a9d$1@newslocal.mitre.org>

What I have done is use a little script to toggle trace on/off using sys.dbms_system.set_sql_trace_in_session for each session out there.

Let it run in trace mode for a while then gather up all the trace files.

--Peter

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.
Received on Tue Dec 23 2003 - 11:21:04 CST