RE: List of user sessions

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 23 Apr 2001 04:41:31 -0700
Message-ID: <F001.002EEF7C.20010423042527@fatcity.com>

This is the script we use for sessions; edit out anything you don't need.

select s.sid sid,
       s.serial# serial#,
       s.lockwait lockwait,
       0 blkby,
       0 blkcnt,
       s.username session_user,
       s.program program,
       s.osuser osuser,
       s.status status,
       s.server server,
       s.command cmd_code,
       s.terminal terminal,
       s.type session_type,
       a.name command,
       p.pid pid,
       p.spid spid,
       p.username process_user,
       i.block_gets + i.consistent_gets logrds,
       i.physical_reads phyrds,
       i.block_changes + i.consistent_changes writes
  from v$session s,
       v$process p,
       v$sess_io i,
       audit_actions a
 where s.paddr = p.addr

   and s.sid = i.sid
   and s.command = a.action
 order by s.sid,

          s.serial#

Regards

Mark

-----Original Message-----
oraquest_at_123india.com
Sent: Monday, April 23, 2001 12:45
To: Multiple recipients of list ORACLE-L

Hi,

i want to know that how will i get to know how many users (along with their identities) who are logged in at any one particular moment of time.

mainak

---

123India.com - India's Premier Portal
Get your Free Email Account at http://www.123india.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: oraquest_at_123india.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: Mark Leith
  INET: mark_at_cool-tools.co.uk

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 Mon Apr 23 2001 - 06:41:31 CDT