set lines 250
set pages 30
set pause off
set feed off
clear break
clear col
col osuser format a12
col username format a10
this is it!
col program format a60
col sid format 99999
col sql_test format a100
break on osuser -
on sid dupl -
on username -
on program skip 1
SELECT osuser ,
sid ,
serial# ,
username ,
program ,
status ,
sql_text
from v$session a,
v$sqltext b
where a.sql_address =b.address(+)
and a.type != 'BACKGROUND'
order by osuser ,
sid ,
address ,
piece
/
-----Message d'origine-----
De: Jared Still [mailto:jkstill_at_cybcon.com]
Date: vendredi 7 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 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)"
>
> <Bruce.Reardon_at_comalco.riotinto.com.au> wrote:
> > 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-----
> > From: sam d [mailto:sam_orafan_at_yahoo.com]
> > 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
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: jkstill_at_cybcon.com
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: Gilbert.Bernard_at_caissedesdepots.fr
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 - 11:28:30 CDT
