Re: Why sessions with no program or user?

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:<b9i33f$eua$1_at_news.is.net.tw>...
> Dear all,
>
> In addition to the six background sessions, there are some sessions (10 in the example below) with no program or user names,
> what are they?
>
> select s.program sprg, s.module, p.program pprg, s.status, count(*)
> from v$session s, v$process p where s.paddr = p.addr
> group by s.program, s.module, p.program, s.status
>
> SPRG MODULE PPRG STATUS COUNT(*)
> --------------- --------------- --------------- -------- ----------
> ORACLE.EXE ORACLE.EXE ACTIVE 6
> SQLPLUSW.EXE SQL*Plus ORACLE.EXE ACTIVE 1
> TOAD.exe T.O.A.D. ORACLE.EXE INACTIVE 1
> jrew.exe ORACLE.EXE INACTIVE 1
> ORACLE.EXE ACTIVE 10
>
> Version: Oracle 8.1.7 on Windows NT.
>
> Regards,
> Dino

10 processes are SNP processes and are equal to job_queue_processes value in your init.ora file. These processes run the Oracle backgroung jobs submitted via dbms_job package. They are also listed as SNP0...SNPx in the alert.log file at database startup time.

6 processes that you refer to are PMON, SMON, CKPT etc.

Furthermore on Win*, these processes are actually threads owned by one Oracle process.

Regards
/Rauf Sarwar Received on Sat May 10 2003 - 18:51:29 CDT