Re: v$process: PID=1 PROGRAM=PSEUDO

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Nov 2004 21:06:03 +0000 (UTC)
Message-ID: <cog2vr$l7q$1@titan.btinternet.com>

Every session (v$session) needs a connection (v$process). But if you are using Shared Servers (previously MTS) then a session has to float somewhere whilst it is not running through a shared server. I believe the PSEUDO process exists as the tag for these sessions that are currently no in a circuit.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

"wagen" <wagen123_at_yahoo.com> wrote in message news:c83c8fbf.0411282035.3389507d_at_posting.google.com...
> What does this process do and why is it required?
>
> Thanks in for advance for any help.
> wagen
Received on Mon Nov 29 2004 - 15:06:03 CST