Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Curious. What is this telling me?
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