Re: Webserver connection pooling and sql trace

From: Valentin Minzatu <v.m.i.n.z.a.t.u._at_.r.o.g.e.r.s.c.o.m>
Date: Tue, 23 Dec 2003 14:26:04 GMT
Message-ID: <0gYFb.158932$%TO.117005@twister01.bloor.is.net.cable.rogers.com>

Ryan,

You may consider this approach: have an "after logon" type of trigger that explicitely turns tracing on for each connection comming from the app server. (Please note that this may very expensive as it will start tracing each of those connections separately).

Cheers,
Valentin

---

To reply, please remove the extra dots in my email address

"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.
Received on Tue Dec 23 2003 - 08:26:04 CST