Re: Webserver connection pooling and sql trace

"Valentin Minzatu" <v.m.i.n.z.a.t.u.@.r.o.g.e.r.s.c.o.m> wrote in message news:<0gYFb.158932$%TO.117005_at_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.

the application server opens 10-20 dedicated processes and leaves them open. never closes them. then different users connect to the database using those dedicated connections.

this is seriously problematic for sqltrace, since my trace files will get huge. Received on Tue Dec 23 2003 - 12:33:00 CST