From daemon Wed Feb 7 02:07:43 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA03694; Wed, 7 Feb 1996 02:07:40 -0500 Message-Id: <9602070707.AA03694@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 2834; Wed, 07 Feb 96 01:50:33 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 7130; Wed, 7 Feb 1996 01:50:27 -0500 Date: Wed, 7 Feb 1996 01:50:27 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "Kaing, Leng M" Subject: Re: parallel Pnnn X-To: oracle-l To: Multiple recipients of list ORACLE-L X-Orig-Date: Wed, 7 Feb 1996 15:58:00 EST 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.