this script may help you :
===========================
rem this script used to observe connected users
select S.SID
,S.username
,S.OSuser
,initcap(S.status) Status
,S.terminal
,decode(S.lockwait,NULL,'No','Yes') Lockwait
,initcap(A.Name) Command
,S.process
,P.SPID "NT_ID"
from v$SESSION S
,v$PROCESS P
,sys.AUDIT_ACTIONS A
where S.username is not null
and A.action = S.command
and P.ADDR = S.PADDR
==========================================
<> Bambang Setiawan <>
>>> <[EMAIL PROTECTED]> 03/07/01 11:40 >>>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Bambang Setiawan
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
