Oracle-L: RE: Can we find SQL user

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 06 Jun 2002 21:58:18 -0800
Message-ID: <F001.00477232.20020606215818@fatcity.com>

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,
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
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 07 2002 - 00:58:18 CDT