Re: parallel Pnnn

From: Kaing, Leng M <LKaing_at_VENTNDS1.TELECOM.COM.AU>
Date: Wed, 7 Feb 1996 01:50:27 -0500
Message-Id: <9602070707.AA03694@alice.jcc.com>

So what's the difference between parallel query and parallel server? My init.ora has:

parallel_max_servers=20
parallel_min_servers=6

No 'shared' but certainly 'parallel'. v$thread shows:

   THREAD# STATUS ENABLED GROUPS INSTANCE OPEN_TIME

• ------ -------- ---------- ---------------- -------------------- 1 OPEN PUBLIC 4 CP_PRD 01/21/96 22:30:47

Is this parallel server? I'm confused.

---

Pnnn processes are Parallel Query processes NOT Parallel Server processes. Parallel Server processes look like ora_lck0_SID. These are the Distributed lock manager interface processes.

You don't have these lock files unless you start your intance with the 'shared'
or 'parallel' options. Received on Wed Feb 07 1996 - 02:07:43 CST