Message-
From: sam d [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 1:18 AM
To: Multiple recipients of list ORACLE-L
Subject: Can we find SQL user
Hi List,
Suppose I have m1,m2,m3 machines,
all the users sitting on these machines are using
oracle 'user1' to connect
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what machine the SQL statement was
fired.
thx
Sam
name--- Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED] wrote:
Have a look at v$session
In particular the
Sam,
It looks like you have read Bruce's answer a little too fast. You might also like
to RTFM the SQL Reference book, section 'functions', entry SYS_CONTEXT - although if
you also want the SQL text, as Mladen said you must any way join V$SESSION and
V$SQLAREA - or V$SQLTEXT if your
Bruce already mentioned using v$session.
Have you tried it? If you try it, you will find it.
Jared
On Friday 07 June 2002 00:13, sam d wrote:
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what
À: Multiple recipients of list ORACLE-L
Objet: Re: Can we find SQL user
Bruce already mentioned using v$session.
Have you tried it? If you try it, you will find it.
Jared
On Friday 07 June 2002 00:13, sam d wrote:
We can definitely find
Hi List,
Suppose I have m1,m2,m3 machines,
all the users sitting on these machines are using
oracle 'user1' to connect to the server.
As all the people are logged in with the same user
name ,Can we find which user(or machine) has issued
which SQL statement.
Thanks
Sam
Have a look at v$session
In particular the osuser, terminal and machine fields - these may help
Also look at the listener log file - this may help
Or do you have an application server sitting in the middle?
HTH,
Bruce Reardon
-Original Message-
Sent: Friday, 7 June 2002 15:18
Hi List,
Yes you can, just join v$session and v$sqlarea.
On 2002.06.07 01:18 sam d wrote:
Hi List,
Suppose I have m1,m2,m3 machines,
all the users sitting on these machines are using
oracle 'user1' to connect to the server.
As all the people are logged in with the same user
name ,Can we find