This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Jul 27, 2013 3:57 AM by yxes2013 RSS

Orphaned process/session

yxes2013 Newbie
Currently Being Moderated

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

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points