Oracle-L: RE: Currently log-in users

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Thu, 11 Apr 2002 12:38:35 -0800
Message-ID: <F001.00442609.20020411123835@fatcity.com>

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        <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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reddy, Madhusudana
INET: Madhusudana.Reddy_at_bestbuy.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