Oracle-L: Parallel execution question

From: Raghu Kota <raghukota_at_hotmail.com>
Date: Thu, 28 Mar 2002 11:58:22 -0800
Message-ID: <F001.004361D3.20020328115822@fatcity.com>

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). Received on Thu Mar 28 2002 - 13:58:22 CST