Database users

Hello All,

How can I find " how many users are connected to the database ,which user is connected to which machine and which user is doing what activity at the database level .

Can somebody help me in this plz.


bYe,

Raj

Code:

---

select  s.sid "sid",
        s.status "status",
        p.spid "o/s sid",
        s.serial# "serial #",
        s.username "db user",
        s.osuser "client user",
        s.server "server",
        s.machine "machine",
        s.terminal "terminal",
        s.program "program"
 from  v$session s,
        v$process p
 where  s.paddr = p.addr
 order by s.status
/

---