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
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 ter
Hi.
I'm going to assume that you're running on NT and have OEM available.
Try this:
connect with DBA Studio
expand the tree under Instance >> Sessions
start sqlplus and run this
set long 1000
set pagesize 999
select sql_text
from v$sqlarea
where sql_text like '%/* OracleOEM */%'
/
you'll
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
,ini
Hi!
Have a look at my shareware tool
named OSession. It's small and
easy to use.
Cheers
DO
email: [EMAIL PROTECTED]
web: www.materialdreams.com
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 5:41 AM
To: Multiple recipients of list ORACLE-L
Hi guys,
It is possi