Oracle 8i (8.1.7) PSEUDO program entry in v$process

From: Damion Reeves <Damion.Reeves_at_sa.pracom.com.au>
Date: Fri, 01 Feb 2002 13:51:54 +1030
Message-ID: <3C5A09D2.7060701@sa.pracom.com.au>

Hi All,

When I execute the following SQL from SQL*Plus to interrogate the v$process dynamic view in an attepmt to show the Oracle server processes (eg PMON, DBW<x>, LGWR, SMON, RECO etc etc) it shows me a PSEUDO program.

Can anyone give me some information as to what the PSEUDO program is ?

Here is the SQL:

column "O/S PID" format a7
column "Unix User" format a15
column "Process Name" format a25
column "Last Activity" format a19
select
	a.spid "O/S PID",
         lower(b.username) "Unix User",
         a.program "Process Name",
         to_char(sysdate-(b.last_call_et)/86400, 'DD/MM/YYYY' 

HH24:MI:SS') "Last Activity"
from

         v$process a,
         v$session b
where
         b.paddr(+) = a.addr;

Thanks,

Damion Reeves
Junior Oracle DBA
Pracom Ltd
Damion.Reeves_at_sa.pracom.com.au                  Received on Thu Jan 31 2002 - 21:21:54 CST