users and what they are doing ?????????
select v2.sid, v2.username, v2.machine, v2.program, v1.sql_text
from V$sql v1, V$session v2
where (v1.address = v2.sql_address or
v1.address = v2.prev_sql_addr)
and v2.username is not null
ORDER BY 1
---Madhu
-----Original Message-----
Sent: Thursday, April 11, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L
I'm sure that everyone is sending you their version of this:
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername format a8 heading 'Process|User'
column terminal format a14 heading 'Terminal'
column pprogram format a26 heading 'Process program'
column susername format a8 heading 'Session|User'
column server format a9 heading 'Server'
column osuser format a8 heading 'Op Sys|User'
column sprogram format a27 heading 'Session program'
select value from v$parameter where name='db_name';
select
sessions_current, sessions_highwater from
v$license;
select
p.username pusername,
s.terminal,
p.program pprogram,
s.username susername,
server,
osuser,
s.program sprogram
from v$process p, v$session s
where addr=paddr(+)
/
"Nguyen,
David M" To: Multiple recipients of list
ORACLE-L
<david.m.nguy <[EMAIL PROTECTED]>
en cc:
@xo.com> Subject: Currently log-in users
Sent by: root
04/11/2002
11:53 AM
Please
respond to
ORACLE-L
How do I check who is currently logging into database, where he is
accessing
from and what he is doing?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
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:
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: Reddy, Madhusudana
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).
