Process Details with SQL Text

SELECT s.sid
     , p.pid
     , p.spid
     , s.process
     , s.status
     , s.username
     , s.osuser
     , s.program
     , a.name
     , s.client_info
     , s.module
     , to_char(s.logon_time,'yyyy-mm-dd hh24:mi:ss')
     , to_char(sysdate - (s.last_call_et /86400),'yyyy-mm-dd hh24:mi:ss')
     , sq.sql_text
     , sq.sql_id
  FROM v$session s
     , v$process p
     , audit_actions a
     , v$sql sq
 WHERE s.paddr = p.addr
   AND s.command = a.action
   AND sq.address (+) = decode(s.sql_address,'00', s.prev_sql_addr, s.sql_address)
ORDER BY s.status;

Field Key

• Oracle Session ID
• Oracle Process ID
• OS Process ID
• OS Client Process ID
• Status of Session
• Oracle Username
• OS Username
• OS Program Name
• Command in Progress
• Client Info from DBMS_APPLICATION_INFO.SET_CLIENT_INFO proc
• Module Info from DBMS_APPLICATION_INFO.SET_MODULE proc
• Time of Logon
• Last Call
• SQL Text