Re: Active users

From: Mats Moller <mll_at_dxcern.cern.ch>
Date: Tue, 1 Dec 1992 10:34:59 GMT
Message-ID: <1992Dec1.103459.16722_at_dxcern.cern.ch>

In order to show the active users try the following:

                select   p.pid pid,
                          s.username ouser,
                          p.username puser,
                          p.program
                from   v$session s,
                           v$process p
                where
                          s.paddr = p.addr
                          order by p.pid 

Need to be run from an account with dba privileges.

---

Mats Moller
CERN
Geneva, Switzerland                               Received on Tue Dec 01 1992 - 11:34:59 CET