Re: PMON Problem : server process without user process

h.jalalipoor_at_gmail.com schrieb:
> I`m sorry, it is a typo on this line :
> oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194
>
> I explain my problem again.
> I execute this query:
> 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
>
> v$session show me that I must have a session with Oracle SID 42, Oracle
> process id 1196 (as server process) and unix process id 1194 (as user
> process).
> but when i search unix process id, i don`t find it. i execute this
> command :
> (oraprod_at_ESCOERP2) > ps -ef|grep 1194
> oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194
>
> (oraprod_at_ESCOERP2) > ps -ef|grep 1196
> oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1196
> oraprod 1196 1 0 08:33:49 ? 3:08 oraclePROD (LOCAL=NO)
>
> The above result show me that i have a session with Oracle SID 42,
> Oracle process id 1196 but no unix process id 1194!
>
> Normally, at this time PMON should clean up the session but it did
> not!. the session remained on the database and don`t clean by PMON.
>
> Thanks.
>

Oh, i understand now.
The SPID from v$process is the os process identifier for corresponding oracle process, so you can find it in the process table on the Oracle server's host. Process from v$session - is the os process identifier of oracle client. The latter can be spawned on the Oracle server's host ( in that case you would find it in the process table on this machine), but can well be on totally another machine ( as probably in your case), so you would find it with ps -ef|grep not on the Oracle server's host, but on the client's host.

Best regards

Maxim Received on Wed Dec 13 2006 - 05:04:42 CST