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 f
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 particula
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 wh
juin 2002 17:58
À: 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 c
Really appreciate it Richard,
This is what I was missing
"where a.sql_address=b.address(+)"
Thx a Lot list,
Sam
--- Richard Huntley <[EMAIL PROTECTED]> wrote:
> Sam, had problems sending this to the list, but
> thought this might help...
> here is what you need...enter the specific usernam
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 statemen