Re: Curious. What is this telling me?

I think you'll find that those are I/O slaves. You probably have some parameter like
async_io_slaves = true.

(The name may be different, I can't remember which ones were around in 8.0.5).

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Ed Stevens wrote in message <3d1374bc.403093097_at_ausnews.austin.ibm.com>...


>Platform:  NT and Oracle 8.0.5

>

>Given the following query:

>

>select spid,

> to_char(logon_time,'dd-mon-yy hh24:mi:ss') started,

> s.status,

> s.osuser,

> p.username,

> substr(p.program,1,45) pgm

>from v$process p,

> v$session s

> where p.addr=s.paddr

>order by logon_time;

>

>I get the following result:

>

>SPID   STARTED              STATUS   OSUSER   USERNAME PGM

>------ -------------------- -------- -------- --------

>---------------------------------------------

>00229  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>0011A  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>001FE  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>0010D  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>00042  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>00216  21-jun-02 13:15:05   ACTIVE   UNKNOWN  UNKNOWN  ORACLE80.EXE

>001F0  21-jun-02 13:17:36   INACTIVE SYSTEM   SYSTEM

>d:\orant80\bin\oracle80.exe

>001B0  21-jun-02 13:25:01   ACTIVE            UNKNOWN  ORACLE80.EXE (I101)

>0004C  21-jun-02 13:25:02   ACTIVE            UNKNOWN  ORACLE80.EXE (I102)

>001F7  21-jun-02 13:25:02   ACTIVE            UNKNOWN  ORACLE80.EXE (I103)

>001F6  21-jun-02 13:25:02   ACTIVE            UNKNOWN  ORACLE80.EXE (I104)

>001FF  21-jun-02 13:25:02   ACTIVE            UNKNOWN  ORACLE80.EXE (I105)

>0021D  21-jun-02 13:25:02   ACTIVE            UNKNOWN  ORACLE80.EXE (I106)

>001AF  21-jun-02 13:25:54   ACTIVE   ATUSER   SYSTEM

>d:\orant80\bin\oracle80.exe

>00212  21-jun-02 13:26:52   ACTIVE   PUR003   SYSTEM

>d:\orant80\bin\oracle80.exe

>

>15 rows selected.

>

>What I'm particularly curious about are those six entries where OSUSER is

null


>and USENAME is 'UNKNOWN'.  Notice that the PGM is qualified with some sort

of ID


>in parentheses.

>

>From a 'human' standpoint, I recognize that the first 6 entries are oracle

>background tasks (pmon, smon, etc?) SPID 001F0 is probably the Oracle

Agent,


>SPID 001AF is a known application job (a sql*plus script executing several

>PL/SQL pgms) and SPID 00212 is my own SQL*Plus session where I issued this

>query.  But what of those other six  (spid 1B0 thru 21D)?

>

>

>

>--

>Ed Stevens

>(Opinions expressed do not necessarily represent those of my employer.)