col username format a10
col osuser   format a10
col machine  format a25
col terminal format a10
col program  format a10
column   sid         format 999
column   serial#     format 9999999
col status   format a8
col sql_text format a100
/
select username
     , osuser
     , machine
--     , terminal, program,
     , sid, serial#
     , status
--     ,sql_address
     , sql_text
  from v$session s
     , v$sqltext q
 where type = 'USER'
   and s.sql_address = q.address
--  and s.status      != 'INACTIVE'
 order by s.sid, s.serial#, q.piece
;


#---------------------------------------------------------------------------------------------------------------------------------

pro+--------+-----+-------+----+----+-------------+-------------+----------------------------------------------------------------+;
pro|sio_sta |  sid|serial#|dis |sha |sha_sta      |osuser       |sql_text                                                        |;
pro+--------+-----+-------+----+----+-------------+-------------+----------------------------------------------------------------+;
select
       '|'||rpad(coalesce(c.status,' '),8)||
       '|'||lpad(coalesce(to_char(c.sid),' '),5)||
       '|'||lpad(coalesce(to_char(c.serial#),' '),7)||
--         c.sql_address,
--         c.paddr,
       '|'||rpad(coalesce(d.name,' '),4)||
       '|'||rpad(coalesce(a.name,' '),4)||
       '|'||rpad(coalesce(a.status,' '),13)||
       '|'||rpad(coalesce(c.osuser,' '),13)||
--       '|'||rpad(coalesce(c.server,' '),9)||
       '|'||rpad(e.sql_text,64)
from
         v$shared_server a,
         v$circuit b,
         v$session c,
         v$dispatcher d,
         v$sqltext e
where
         c.username != 'SYS'
         and c.status = 'ACTIVE'
         and c.type = 'USER'
         and c.sql_address = e.address
         and d.paddr(+) = b.dispatcher
         and a.circuit = b.circuit(+)
         and a.paddr(+) = c.paddr
order by
         c.sid,
         c.serial#,
         e.piece;
pro+--------+-----+-------+----+----+-------------+-------------+----------------------------------------------------------------+;
pro|sio_sta |  sid|serial#|dis |sha |sha_sta      |osuser       |sql_text                                                        |;
pro+--------+-----+-------+----+----+-------------+-------------+----------------------------------------------------------------+;