Re: Can Parallel query run with dual core processor ?
Date: Mon, 9 Jun 2008 11:42:30 -0700 (PDT)
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
> >Can I run parallel query in it ?
> >Thank you,
> 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
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
-- @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.htmlReceived on Mon Jun 09 2008 - 13:42:30 CDT