Re: What is ORACLE.EXE (PXXX) ???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 Oct 2001 13:36:53 +0200
Message-ID: <ttiodtahlpumfd@corp.supernews.com>

"Anonymous" <mail_for_deja_at_yahoo.com> wrote in message news:8ee5d7c9.0110260139.a66d2d_at_posting.google.com...
> When I issue "select terminal, username, program from v$session", I
> see:
>
> TERMINAL USERNAME PROGRAM
> ---------------- ------------------------------
> ------------------------------
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> USER1 SYSTEM F45RUN32.EXE
> USER1 SYSTEM ORACLE.EXE (P000)
> USER1 SYSTEM ORACLE.EXE (P002)
> USER1 SYSTEM ORACLE.EXE (P003)
> USER1 SYSTEM SQLPLUSW.EXE
> USER1 SYSTEM ORACLE.EXE (P001)
>
> What is "ORACLE.EXE (PXXX)"? I found that SYSTEM only login one
> session with SQL*Plus and one session with Oracle Forms Runtim, but
> why there are four ORACLE.EXE (PXXX)? (Oracle8i on Windows 2000,
> client is Windows 98)
>

You have configured 4 parallel query slaves.

Regards,

Sybrand Bakker
Senior Oracle DBA

> David
Received on Fri Oct 26 2001 - 06:36:53 CDT