RE: Connected users ??

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 06 Mar 2001 22:07:00 -0800
Message-ID: <F001.002C5761.20010306212049@fatcity.com>

v$session will tell you this

Try something like the following.

Regards,
Bruce

Originally from Deepak Thapliyal on this list and since modified number of times by me.

start here ---

set pagesize 40
set linesize 500
SET FEEDBACK ON col username format a14 wrap
col osuser format a11
col terminal format a10
col program format a20 wrap
col machine format a10
col type format a4 truncate
col logon_time heading 'Logon-Start-Time' format a18 col "DOING?" format a8
col module format a10
col sid format 999
col serial# format 999999
--clear screen

SELECT
   a.username,
   a.osuser,
   decode ( terminal , 'Windows NT PC' , machine , terminal ) Terminal ,    a.program,
   type,
   to_char(a.logon_time,'DD-MON-YY HH24:MI:SS') logon_time,    ltrim(rtrim(substr(b.name,1,10))) "DOING?",    substr(a.module,1,10) module,
   a.sid,
   a.serial# ,
   last_call_et secs_inact
FROM
   v$session a, sys.audit_actions b
WHERE
   b.action = a.command
;

end here ---

-----Original Message-----

Sent: Wednesday, 7 March 2001 15:41
To: Multiple recipients of list ORACLE-L

Hi guys,

It is possible to list all user that currently connected to my Oracle8i ? and what is the command or script or source of information ?

Thank you,

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: sinardyxing_at_bcsis.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

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