RE: Parallel execution question

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 28 Mar 2002 12:33:30 -0800
Message-ID: <F001.004362ED.20020328123330@fatcity.com>

Read all articles on Parallel Query at Jonathan's web site:

http://www.jlcomp.demon.co.uk/ind_pqo.html

You will know how it works and why...

• Kirti

-----Original Message-----
Sent: Thursday, March 28, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L

Hi Friends,

I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters..

PARALLEL_MIN_SERVERS
PARALLEL_MAX_SERVERS
PARALLEL_MIN_PERCENT

My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! I have 8 CPUs with 2GB RAM on AIX415.

Any info regarding that appreciatiable!!

Thanks in advance
Raghu.

---

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Raghu Kota
  INET: raghukota_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 28 2002 - 14:33:30 CST