Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PMON Problem : server process without user process

PMON Problem : server process without user process

From: <h.jalalipoor_at_gmail.com>
Date: 13 Dec 2006 00:22:25 -0800
Message-ID: <1165998145.508964.25800@16g2000cwy.googlegroups.com>


Hi

I Have a server process with an active session, but no corresponding user process. normally, at this time PMON should clean up the session but it did not!.
I don`t understand what happened in the database internal, i`m confused!

I execute this statements :

SQL> select s.status, s.sid, s.process, s.machine, s.taddr, p.spid from v$session s, v$process p
where s.paddr=p.addr
and s.sid=42
/
STATUS SID PROCESS MACHINE TADDR SPID

-------- ----- --------- ---------- ---------------- -------
ACTIVE      42 1194      ESCOERP2   C0000000DFB40EF8 1196


(oraprod_at_ESCOERP2) > ps -ef|grep 1196

oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194 oraprod 1196 1 0 08:33:49 ? 3:08 oraclePROD (LOCAL=NO)

(oraprod_at_ESCOERP2) > ps -ef|grep 1194

oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194

SQL> select * from v$transaction t
where t.ADDR in (select s.TADDR from v$session s where sid=42)

No row select.

The session remained on the database and don`t clean by PMON.

Can you please help me. Received on Wed Dec 13 2006 - 02:22:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US