Re: Help:How do you trace in this application?

On 17.12.2007 21:44, emdproduction_at_hotmail.com wrote:
> By one user, I meant no matter who loged into the application from the
> web interface, from database end, I only see one user name, if I
> select username from v$session, I got several app_user, with different
> sid, from the same machine, which is the application server machine,
> and same program, which wex.exe, and the same username, which is
> app_user.
>
> How could I trace it for a particular user, if they all login with the
> same credential?

In the worst case you simply have to trace all sessions of this user, make your "special" user execute the commands you are interested in and switch off tracing for all again. Then you only need to find the SQL in the trace files from this exercise. Granted you'll likely collect much more than you need but if you keep the time window small that might be feasible. All in all I haven't found a good way to collect properly scoped data in such a scenario. And the situation is even worse when there is a connection pool for DB connections...

Kind regards

        robert Received on Mon Dec 17 2007 - 15:10:46 CST