1 2 Previous Next 17 Replies Latest reply: Jul 27, 2013 5:57 AM by yxes2013 RSS

    Orphaned process/session

    yxes2013

      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