From: TMAN <shadow_man_600@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Parallel Query work on 1 CPU machine?
Date: Wed, 04 Apr 2001 09:30:36 -0500
Organization: Jump.Net, Inc.
Lines: 72
Message-ID: <3ACB300C.7839C447@yahoo.com>
References: <331x6.313$tG2.97887@dfiatx1-snr1.gtei.net> <Uqex6.120199$W05.23113402@news1.rdc1.mi.home.com>
Reply-To: shadow_man_600@yahoo.com
NNTP-Posting-Host: bang.mesas.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.jump.net 986394640 25380 207.8.19.101 (4 Apr 2001 14:30:40 GMT)
X-Complaints-To: abuse@jump.net
NNTP-Posting-Date: Wed, 4 Apr 2001 14:30:40 +0000 (UTC)
To: Tom Weng <tomweng@home.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en


You may want to try using  parallel_min_servers =1 or even 2 .  Then check at
the OS level to make sure there are 2 processes running , they should look
something like "ora_p002_prod1db" in unix, not sure about NT.  Also for your
hint you might try  "/*+ PARALLEL (table, DEGREE) */" where degree is the
number of pieces the query is broken into, in your case try maybe 2 to start
with.  If you don't specify a degree then the hint uses the default degree of
parallelism dictated by the table, which could be why the hint isn't spawning
any PQS.

Just a few thoughts.

Thom Crider


Tom Weng wrote:

> I will be interesting to know the answer as well, actually, is there a
> guideline /system specification especially in hardware-wide from Oracle for
> the platform Oracle support(NT/SUN/AIX..)
> to configure parallel execution?
>
> Can somebody provide where to look for this kind of document/.pdf?  I tried
> OTN but no luck!
>
> Tom
>
> "Maria Walski" <mwalski@classicplan.com> wrote in message
> news:331x6.313$tG2.97887@dfiatx1-snr1.gtei.net...
> > Hello,
> >
> > I am trying to play on a test machine with the Parallel Query Option. I
> > cannot seem to get a query to perform a parallel full table scan. I have
> > searched on metalink and I believe I have all the proper init.ora
> > parameters set:
> > NT 4.0, Oracle 8.1.7 Enterprise Edition.
> > parallel_threads_per_cpu = 2
> > parallel_min_servers = 0
> > parallel_max_servers = 5
> >
> > The test machine only has 1 CPU, does the parallel query even work if the
> > machine only has 1 CPU? I realize you need more than 1 cpu for it to be
 very
> > beneficial, however, I am not really concerned with the performance, but I
> > would just like to see a query use the parallel option.
> >
> > To Test:
> >
> > I built a 1,000,000 row table and I am using the following query:
> >
> > SELECT /*+ FULL(TEST) PARALLEL */ COUNT(*)
> > FROM TEST
> >
> > When I do an explain plan, I cannot seem to get any parallel execution.
> >
> > I also tried
> > SELECT /*+ FULL(TEST) PARALLEL(3) */ COUNT(*)
> > FROM TEST
> >
> > Is there something I am missing or must you have > 1 CPU? Is 1,000,000
 rows
> > too small?
> >
> > Thanks, Jim
> >
> >
> >
> >
> >
> >
> >
> >