Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Curious. What is this telling me?

Re: Curious. What is this telling me?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 21 Jun 2002 20:20:28 +0100
Message-ID: <3D137C7C.6898@yahoo.com>


Ed Stevens wrote:
>
> 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.)

I think IO slaves come up as 'Innn' (but I'm not near the doco at the moment do don't take that as gospel).

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Fri Jun 21 2002 - 14:20:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US