Xref: alice comp.databases.oracle.server:79491
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!crtntx1-snf1.gtei.net!crtntx1-snh1.gtei.net!washdc3-snh1.gtei.net!news.gtei.net!paloalto-snr1.gtei.net.POSTED!not-for-mail
Message-ID: <386E5A6C.E026E8FA@cc.gatech.edu>
From: Paul Bennett <bennett@cc.gatech.edu>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: using all available CPUs
References: <84ese1$mbj$1@redftp.redftp.attws.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
X-Trace: /KiKeTBoXjoNFpWKI3oqEKcat7qK0/0sVq9WdH67DCkEJvQnsWsSDDA9PnQUHlx97NAP6H+m+rRP!k7e3fGSk8CZS7/BLsOXpSszVK12mnQLmcDafOy095CTRBC4qtXARc10=
X-Complaints-To: abuse@gte.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Sat, 01 Jan 2000 19:49:10 GMT
Distribution: world
Date: Sat, 01 Jan 2000 19:49:10 GMT

This brings up another question.

The OPQ section of database concepts discusses what is necessary to make one SQL
statement execute in parallel, but it does not discuss what is necessary for
different SQL statements to be processed in parallel.  If four different users
execute four different SQL statements on a four processor machine, does each
statement get it's own processor?  Do the tables have to be different?  Do the
tables have to reside in different tablespaces?  What are some more constraints,
or where can I find information about this?

Thanks.

-- Paul

Verna Legaspi wrote:

> Hello.  We have a Sun E4000 with 6 CPUs.  Running Solaris 2.6 & Oracle
> 8.0.5.  Is there some parameter, setting, option, etc. that I need to
> configure in order for Oracle to take advantage of all the CPUs?  Or is this
> only something that can be done on the SQL side?