RE: REm: who's connected to database

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Mon, 18 Sep 2000 16:52:48 -0700
Message-Id: <10623.117299@fatcity.com>

I too got this requirement, but what I needed was an IP address of the workstation. I could n't find it in V$session and I couldn't find any other way to get the IP addr. I would appreciate if someone could help us.

Thanks,
-- Janardhana Babu
-----Original Message-----
From: Gunawan Yuwono [mailto:gunawan.yuwono_at_webbox.com] Sent: Monday, September 18, 2000 5:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: REm: who's connected to database

Try v$session:
select username, osuser, machine from v$session;

Describe v$session and see what other fields you might want to display such as logon_time, etc.

HTP. Gunawan Yuwono
Oracle DBA
Kansas City, MO

>--- Original Message ---
>From: "Leyden, Joseph" <LeydenJ_at_MTA.NET>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 9/19/00 12:00:20 AM
>

>is there a command to find out who are
>currently connected to the database and from
>what workstation addr or name?
>
>any help is much appreciated.
>--
>Author: Leyden, Joseph
> INET: LeydenJ_at_MTA.NET
>
>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).
>
>

---

Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others!

-- 
Author: Gunawan Yuwono
  INET: gunawan.yuwono_at_webbox.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 Sep 18 2000 - 18:52:48 CDT