I believe it exists so that sessions which are
currently not attached to real processes (e.g.
sessions which are not currently in a virtual
circuit with MTS) have a process that they can
be associated with.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Damion Reeves wrote in message <3C5A09D2.7060701_at_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 Fri Feb 01 2002 - 01:41:45 CST
