Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Tuesday, 9 September 2008

Oracle Process Details

A useful query to check database processes:

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')
  from v$session s
     , v$process p
     , audit_actions a
 where s.paddr = p.addr
   and s.command = a.action
 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
  • No comments: