Parallel Server and Parallel Query Processing

Parallel Server and Parallel Query Processing

Post by DrowningPeop » Thu, 23 Aug 2001 04:40:40



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?
 
 
 

Parallel Server and Parallel Query Processing

Post by Sybrand Bakke » Thu, 23 Aug 2001 04:50:41



Quote:> 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?

no and no

Regards,

Sybrand Bakker, Senior Oracle DBA

 
 
 

Parallel Server and Parallel Query Processing

Post by Pete Sharma » Thu, 23 Aug 2001 08:23:43


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


Quote:> 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?

 
 
 

1. MA-BOSTON-69103--ORACLE-DBA Skills-Parallel Processing-Customer Support-Oracle DBA w/Parallel Processing

******** VISIT US AT http://www.selectjobs.com ***********
=
*************************************************************
Company    : Oracle Corporation
Website    : http://www.oracle.com
Job Title  : Oracle DBA w/Parallel Processing
Location   : BOSTON, MA
Job Type   : Full-Time Salaried
============================
Oracle's Support Services Field Organization is seeking the "Best of the Best"
technical professionals.

As the on-site "Oracle Expert", you will plan/implement proactive support
strategies, as well as provide Fortune 500 customers with technical account
management. These highly-visible positions require a BS degree, at least 5
years experience in Oracle Database Administration, 1 year experience in
Parallel Processing, and excellent customer service abilities.

Travel Required          :None
Educational Requirements :Bachelors Degree
=
Required Skills
* ORACLE
* DBA Skills
* Parallel Processing
* Customer Support
=
Oracle Corporation offers generous compensation and unparalleled benefits.
Oracle supports workforce diversity.
=
Contact Information:
Reference : 1027
Jan Ackerman
Oracle Corporation
508 Eagle Circle

Casselberry, FL 32707

Phone: 407-696-2337
   -   -    
Fax No: 407-696-2337
***********************  http://www.selectjobs.com  ****************************

                The On-Line, On-Target Job Finder for Computer Professionals  

** Post Your Resume and see results immediately!! ** Always free **
** Matching Resumes E-mailed daily
**  Your ads are virtually guaranteed to be seen by jobseekers on the NET **

                    ** Automatic Posting to **
   ** Yahoo            ** Americas Job Bank    ** AltaVista   *** ClassifiedsWarehouse
   ** erpcentral.com   ** Classifieds 2000     ** Usenet Newsgroups
           ** VBOnline.com   ** ORASearch.com  
               *** OVER 100 MILLION HITS/MONTH COMBINED !!! ***

***********************  http://www.selectjobs.com  ****************************

2. Sybase DBA's and Programmers sought by Palo Alto Startup

3. Parallel Server and Parallel Query

4. Changing Serialized CustNo?

5. SQL Server 7 and parallel query processing.

6. page linkage traversed with BAD PREV pointers

7. parallel query server stays on hp for killed processes

8. DataCombo

9. Deactivate Parallel Query Server processes

10. Oracle processes and parallel execution server processes

11. Parallel Query - co-ordinator/slave processes statistics

12. Identifying Parallel Query Processes and Sessions