Re: Why sessions with no program or user?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 10 May 2003 08:40:54 +0200
Message-ID: <pm7pbv8944so0ol41fe3k7hs5tatrtm8k4@4ax.com>

On Sat, 10 May 2003 13:34:21 +0800, "Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote:

>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
>

Where do you see 10 sessions at all in the mangled data you posted?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat May 10 2003 - 01:40:54 CDT