see_active_sql.sql

set line 240
set verify off
column sid format 99
column pid format 99
column S_# format 99
column username format A9 heading "ORA User"
-- column program  format a29
column SQL      format a60
COLUMN OSname format a9 Heading "OS User"
 SELECT
 P.pid pid,
 S.sid sid,
 P.spid spid,
 S.username username ,
 S.osuser osname,
 substr(P.terminal,1,5) terminal,
 substr(P.program,1,8)  program,
 P.background,
 S.status,
 RTRIM(SUBSTR(a.sql_text, 1, 300))  SQL
 FROM v$process P, v$session S,
      v$sqlarea A
 WHERE P.addr = s.paddr
 AND   S.sql_address = a.address (+)
 order by S.username
/