Re: Can Parallel query run with dual core processor ?

On Jun 8, 4:51 am, sybra..._at_hccnet.nl wrote:
> On Sun, 8 Jun 2008 01:10:43 -0700 (PDT), krisl..._at_gmail.com 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 http://oracledoug.com/papers.html

jg

--
@home.com 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
http://www.signonsandiego.com/news/metro/20080607-9999-1n7bidwell.html