From daemon Wed Feb 7 15:08:39 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA11223; Wed, 7 Feb 1996 15:08:24 -0500 Message-Id: <9602072008.AA11223@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 3527; Wed, 07 Feb 96 14:01:12 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 1213; Wed, 7 Feb 1996 14:01:09 -0500 Date: Wed, 7 Feb 1996 19:02:28 +0000 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Andri Kisseleff Subject: Re: parallel Pnnn X-To: "ORACLE database mailing list." To: Multiple recipients of list ORACLE-L Lien You have setup the "parallel query option" (and not "parallel server option"). Parallel query allows to parallise certain SQL-Statements on different processors on a multi-processor box. (Full table scans, sorts, sub-queries, etc.) This option is mainly used for performance reasons. Parallel server allows to set up multiple instances on different boxes sharing the same disks (a VAX CLUSTER is a typical sample). This option is mainly used for high availability reasons. (Performance can be worse for example in non partitionned OLTP environments) Bye the way: Both options must be licensed (Dollar...), at least here in Switzerland. We do recommend testing the parallel query option carefully, as several clients have found some quiet serious bugs. (For ex. under Oracle 7.1.3 on Vax OpenVMS) Regards, Andri At 11:51 07.02.96 +0000, you wrote: >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. > ================================================================================ Andri Kisseleff SQL Consult AG Rebhaldenweg 1 Elisabethenanlage 9 CH-5507 Mellingen CH-4051 Basel Tel: ++41 56 470 61 31 Tel: ++41 61 272 87 55 Fax: ++41 56 470 61 32 Fax: ++41 61 272 87 56 Mail: akissele@sql-consult.ch ================================================================================