RE: How to find osuser and machine name connected to database

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 22 Aug 2000 13:05:20 -0500
Message-Id: <10597.115261@fatcity.com>

This is what we use to capture the current number of users in each = instance.

select distinct to_char(to_date(value,'J')) SD, sysdate, '&SERVER'a, db.name, username, =20
osuser, machine=20

         from v$session@&DBLINK, v$instance@&DBLINK, v$database@&DBLINK = db

                 where key=3D'STARTUP TIME - JULIAN'

-----Original Message-----
From: Lyall Barbour [mailto:lbarbour_at_stanford.edu] Sent: Tuesday, August 22, 2000 10:45 AM
To: Multiple recipients of list ORACLE-L Subject: Re: How to find osuser and machine name connected to database

That's where you'd look, but I think you can send that kind of = information=20
through the forms. SET_APPLICATION_somethingorother. It's been a = while=20
since I did forms.

Good Luck,
Lyall Barbour

At 01:59 AM 8/22/00 -0800, you wrote:
>Hi folks,
> I want to know the operating system username and
>machine name of the user who is connected to database.
>
>I tried v$session view, But In case of user connected
>through forms 4.5 I am getting the os_user as
>'OraUser'
>and machine =3D NULL .
>I also tried to find it from the Listener.log on the
>server, but same problem.
>
>can anybody help me out.
>
>Thanks in advance.
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Mail =AD Free email you can access from anywhere!
>http://mail.yahoo.com/
>--
>Author: Abhijit Bhivapure
> INET: abhivapure_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).

--=20
Author: Lyall Barbour
  INET: lbarbour_at_stanford.edu

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 Tue Aug 22 2000 - 13:05:20 CDT