Currently log-in users
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).
Re: Currently log-in users
Start with v$session. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 11:53 AM 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: Igor Neyman 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).
RE: Currently log-in users
v$session would be a good startin place. Dave -Original Message- Sent: Thursday, April 11, 2002 10:53 AM To: Multiple recipients of list 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: Farnsworth, Dave 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).
Re: Currently log-in users
Hi, You may use the view V$SESSION. Regards M.Emre HANCIOGLU Masterfoods Services GmbH Nguyen, David M [EMAIL PROTECTED] xo.com Sent by: [EMAIL PROTECTED] 11.04.02 17:53 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Currently log-in users 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).
Re: Currently log-in users
Some selects You can find in http://www.itsystems.lv/gints/dba_selects.htm I'm sure there are websites with more scripts around the net, of course... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ 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: 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).
Re: Currently log-in users
Here's a good starting point. If you want I also have a unix shell script
driver for this that does a little more formatting.
set feedback off
set heading off
set timing off
set time off
set echo off
set term off
set pagesize 256
set space 1
column username format a8
column machine format a8
column terminal format a8
column logon_time format a18
column SESSION ID format a11
column module heading FORM format a20
spool /tmp/logged_in.lst
select username,
substr(machine,1,8),
substr(terminal,1,8),
to_char(logon_time,'DD-MON-YY HH:MI am') logon_time,
||sid||','||serial#|| SESSION ID,
nvl(substr(module,1,20), 'Character session')
from v$session
where type = 'USER' and username != 'SYSTEM'
and username is not null and status != 'KILLED';
spool off
prompt
prompt
spool /tmp/logged_in2.lst
select 'Total Users currently logged in'||' '||count(*) from v$session
where type = 'USER'
and username != 'SYSTEM';
spool off
spool /tmp/logged_in3.lst
select 'GUI users logged in: '||' '||count(*)
from v$session
where machine != ('mufasa')
and username != 'SYSTEM';
spool off
exit
Joe LaCascio
Oracle DBA, Unix Administrator
Wheaton College, MA 508.286.3405
On Thu, 11 Apr 2002, Nguyen, David M wrote:
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: Joe LaCascio
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).
Re: Currently log-in users
Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME, to_char(round(c.seconds_in_wait/3600,0))||'.'|| to_char(round(mod(c.seconds_in_wait,3600)/60,0)) HOUR, a.osuser OS_USER, a.username ORACLE_USER, b.program PROGRAM, b.spid PROCESS_NR, a.sid SID, a.serial# SERIAL# from v$session a, v$process b, v$session_wait c where a.paddr=b.addr and a.sid=c.sid / 2- set linesize 120 select SADDR, SID, SERIAL#, PADDR, substr(USERNAME,1,8) USER, STATUS STATUS_, SCHEMA#, OSUSER, PROCESS, LOGON_TIME, LAST_CALL_ET from v$session order by osuser / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Apr 2002 07:53:26 -0800 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). MOHAMMAD RAFIQ _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
RE: Currently log-in users
Thanks for the script. It is useful for me. David -Original Message- Sent: Thursday, April 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME, to_char(round(c.seconds_in_wait/3600,0))||'.'|| to_char(round(mod(c.seconds_in_wait,3600)/60,0)) HOUR, a.osuser OS_USER, a.username ORACLE_USER, b.program PROGRAM, b.spid PROCESS_NR, a.sid SID, a.serial# SERIAL# from v$session a, v$process b, v$session_wait c where a.paddr=b.addr and a.sid=c.sid / 2- set linesize 120 select SADDR, SID, SERIAL#, PADDR, substr(USERNAME,1,8) USER, STATUS STATUS_, SCHEMA#, OSUSER, PROCESS, LOGON_TIME, LAST_CALL_ET from v$session order by osuser / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Apr 2002 07:53:26 -0800 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). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: 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).
Re: Currently log-in users
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).
RE: Currently log-in users
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).
