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

From: <emdproduction_at_hotmail.com>
Date: Mon, 17 Dec 2007 12:44:31 -0800 (PST)
Message-ID: <28aab6a0-4303-4abd-8928-4ce1d731e1f4@i12g2000prf.googlegroups.com>

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?

Thanks

>
> Hi,
>
> I'm not sure I understand what you mean by "one user". Are you saying
> the oracle user, or the OS user that runs the application software on
> the application server? Are either the Oracle user or the OS user on
> application server unique (apart or in combination)? What do you see
> when select distinct client_identifier from gv$session?
>
> Regards,
>
> Steve
Received on Mon Dec 17 2007 - 14:44:31 CST