Re: Can Parallel query run with dual core processor ?

From: <sybrandb_at_hccnet.nl>
Date: Sun, 08 Jun 2008 13:51:01 +0200
Message-ID: <fqhn449isrol4nqqplcjqmor8bfo8b8jsn@4ax.com>


On Sun, 8 Jun 2008 01:10:43 -0700 (PDT), krislioe_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.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Sun Jun 08 2008 - 06:51:01 CDT

Original text of this message