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
/