Oracle Database Discussions

Hi all,

11.2.0.3

I got this query to list orphaned processes:

SQL>

Select USERNAME,PROGRAM,ADDR,PID,SPID,SERIAL# From v$process

Where addr NOT IN (SELECT paddr FROM v$session);

  3

SQL> Select USERNAME,PROGRAM,ADDR,PID,SPID,SERIAL# From v$process Where addr NOT IN (SELECT paddr FROM v$session);

USERNAME        PROGRAM

--------------- ------------------------------------------------

ADDR                    PID SPID                        SERIAL#

---------------- ---------- ------------------------ ----------

                PSEUDO

0700000021078C50          1                                   0

oracle          oracle@debbie (D000)

0700000021088F50         17 2895974                           1

oracle          oracle@debbie (S000)

0700000021089F80         18 2248724                           1

===========

I can see the above process are oracle background? Is it possible they can be orphaned?

Thanks,

zxy