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

From: Yong Huang <yong321_at_yahoo.com>
Date: 29 Nov 2004 12:18:23 -0800
Message-ID: <b3cb12d6.0411291218.63e93dec@posting.google.com>

wagen123_at_yahoo.com (wagen) 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

I've never figured out what this is used for. According to Metalink thread 609973.999, the pseudo process "serves as a temporary storage area for shared server and XA connections". This "process" can't be traced using SQL trace because there's no session for it, can't be debugged by oradebug because the "process" "is not active" (ORA-72) and can't be traced at OS level because there's no OS process or thread. I run the database in shared server mode (dispatchers='(PROTOCOL=TCP)(SERVICE=ORCL)', shared_servers=5)), and it makes no difference.

Yong Huang Received on Mon Nov 29 2004 - 14:18:23 CST