Curious. What is this telling me?

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Fri, 21 Jun 2002 18:48:51 GMT
Message-ID: <3d1374bc.403093097@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.)

Received on Fri Jun 21 2002 - 13:48:51 CDT