background_process.sql

COLUMN sid FORMAT 99999 HEADING 'Sid'
COLUMN serial# FORMAT 99999 HEADING 'Serial#'
COLUMN Program FORMAT a25 word_wrap HEADING 'Program'
COLUMN pid FORMAT 99999 HEADING 'Pid'
COLUMN spid FORMAT 999999 HEADING 'Spid'
COLUMN osuer FORMAT a10 HEADING 'OSUser' TRUNC
COLUMN terminal FORMAT a10 word_wrap HEADING 'Terminal'
COLUMN machine FORMAT a25 word_wrap HEADING 'Machine'
COLUMN logon_time HEADING 'Logon_time'
COLUMN Name FORMAT a10 word_wrap HEADING 'Name'
COLUMN Description FORMAT a25 word_wrap HEADING 'Description'


select
 A.SID,
 A.SERIAL#,
 A.PROGRAM,
 P.PID,
 P.SPID,
 A.OSUSER, /* Who Started INSTANCE */
 A.TERMINAL,
 A.MACHINE,
 to_char(A.LOGON_TIME, 'DD-MON-YY') logon_time,
 B.NAME,
 B.Description
from
 v$session A,
 v$process P,
 v$bgprocess B
where
 A.PADDR=B.PADDR
AND A.PADDR=P.ADDR
and A.type='BACKGROUND'
;