Re: Can Parallel query run with dual core processor ?

From: joel garry <>
Date: Mon, 9 Jun 2008 11:42:30 -0700 (PDT)
Message-ID: <>

On Jun 8, 4:51am, wrote:
> On Sun, 8 Jun 2008 01:10:43 -0700 (PDT), wrote:
> >Hi all,
> >I am running Oracle 10g on Redhat Linux, on dual core single
> >processor.
> >Can I run parallel query in it ?
> >Thank you,
> >xtanto
> Theoretically yes, but it doesn't make sense.
> Using parallel query, you always have one session coordinating the
> query, and the others running the actual query.
> On a dual core processor, this would leave on session to run the
> query.

I do think you are right, but I'd say to the OP test it under a realistic load anyways, because sometimes you can see unexpectedly good or bad results with lots of processes fighting for system resources, a lot depends on the balance between cpu and I/O loads and what-all is going on. And the bad can be very educational, for example if you see the coordinating session make the whole thing slower than non-parallel because adding a little more load to the cpu drives it all downhill fast.

Good info on


-- is bogus.  I know that everyone thinks there was some grand
conspiracy, that I was a puppet, that I fell on the sword, that I was
a good team player. No, I was a moron. - Michael McSweeney
Received on Mon Jun 09 2008 - 13:42:30 CDT

Original text of this message