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 /