RE: who's connected to database

Joseph,

all this information can be retrieved from v$session. You need to have DBA privileges to query that view.

hth,
Helmut

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Leyden,
> Joseph
> Sent: Monday, September 18, 2000 05:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: REm: who's connected to database
>
>
> 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).
Received on Mon Sep 18 2000 - 18:57:14 CDT