Welcome mate ,
Same question I posted a month back
First get the
select osuser,sid from v$session;
then use sid in foll. query
SELECT sql_text FROM v$sqlarea WHERE (address,
hash_value) IN
(SELECT sql_address, sql_hash_value FROM v$session
WHERE sid = &sid_number)
- sam d <sam_orafan_at_yahoo.com> wrote:
> Date: Sun, 9 Jun 2002 20:47:31 -0700 (PDT)
> From: sam d <sam_orafan_at_yahoo.com>
> Subject: RE: Can we find SQL user
> To: ORACLE-L_at_fatcity.com
> CC: Richard Huntley <rhuntley_at_mindleaders.com>
>
> Really appreciate it Richard,
>
> This is what I was missing
> "where a.sql_address =b.address(+)"
>
> Thx a Lot list,
> Sam
>
> --- Richard Huntley <rhuntley_at_mindleaders.com>
> wrote:
> > Sam, had problems sending this to the list, but
> > thought this might help...
> > here is what you need...enter the specific
> username
> > then look at the
> > MACHINE field:
> >
> > column username format a12;
> > column osuser format a10;
> > column machine format a20;
> > select
> >
>
username,osuser,server,machine,sid,serial#,status,program,
> > TO_CHAR(logon_time,'DD-MON-YYYY HH24:MI:SS')=20
> > from v$session
> > where username =3D '&username'
> > /
> >
> > -----Original Message-----
> > From: sam d [mailto:sam_orafan_at_yahoo.com]
> > 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 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: sam d
> > INET: sam_orafan_at_yahoo.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).
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sam d
INET: sam_orafan_at_yahoo.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).
Received on Mon Jul 22 2002 - 02:08:21 CDT
