Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Currently log-in users

Re: Currently log-in users

From: <tday6_at_csc.com>
Date: Thu, 11 Apr 2002 11:23:24 -0800
Message-ID: <F001.00442336.20020411112324@fatcity.com>

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        <ORACLE-L_at_fatcity.com>                            
                    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: david.m.nguyen_at_xo.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: INET: tday6_at_csc.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).
Received on Thu Apr 11 2002 - 14:23:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US