Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: REm: who's connected to database

RE: REm: who's connected to database

From: Gunawan Yuwono <gunawan.yuwono_at_webbox.com>
Date: Mon, 18 Sep 2000 16:36:59 -0700
Message-Id: <10623.117298@fatcity.com>


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! Received on Mon Sep 18 2000 - 18:36:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US