Re: Help:How do you trace in this application?
- From: Steve Howard <stevedhoward@xxxxxxxxx>
- Date: Mon, 17 Dec 2007 11:38:18 -0800 (PST)
On Dec 17, 9:01 am, emdproduct...@xxxxxxxxxxx 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
.
- Follow-Ups:
- Re: Help:How do you trace in this application?
- From: emdproduction
- Re: Help:How do you trace in this application?
- References:
- Help:How do you trace in this application?
- From: emdproduction
- Help:How do you trace in this application?
- Prev by Date: Re: querying an identical database on an alternate server
- Next by Date: Re: RAC cache fusion details
- Previous by thread: Re: Help:How do you trace in this application?
- Next by thread: Re: Help:How do you trace in this application?
- Index(es):
Relevant Pages
|
|
