Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PMON Problem : server process without user process
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