Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel Server and Parallel Query Processing
Nope. Parallel Server allows you to take advantage of a multi=node cluster
for availability and performance. Parallel Query allows you to break a
select statement or DML statements into multiple smaller chunks and have PQ
slaves execute those smaller chunks on separate CPU's in a single box. If
you have both you can split the DML across multiple nodes for even further
performance improvement, but it's not needed.
-- HTH. Additions and corrections welcome. Pete Author of "Oracle8i: Architecture and Administration Exam Cram" Now got a life back again that the book is released! "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "DrowningPeople" <turboridelover_at_yahoo.com> wrote in message news:dc7ccafd.0108211140.4bfd95ee_at_posting.google.com...Received on Tue Aug 21 2001 - 18:23:43 CDT
> Are parellel server the same as parallel query processing? If I want
> oracle to do parallel query processing, do I have to have the
> parallel server installed?