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

On Dec 17, 9:01 am, emdproduct..._at_hotmail.com wrote:
> Group,
>
> One of my application is going through an application server. All the
> user is connecting through one user, IP address is the same, and
> programe is the same.
>
> I tried
>
> CREATE OR REPLACE TRIGGER logon_trigger
> AFTER LOGON
> ON DATABASE
> DECLARE
> uid VARCHAR2(64);
> BEGIN
> SELECT ora_login_user ||':'|| SYS_CONTEXT('USERENV', 'OS_USER')
> INTO uid
> FROM dual;
> dbms_session.set_identifier(uid);
> END logon_trigger;
> /
>
> But all the client_identifier is the same.
>
> How could I trace an particular user if he logs in into the
> application?
>
> Thanks very much for your help.

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 - 13:38:18 CST