Re: Can Parallel query run with dual core processor ?

From: <>
Date: Sun, 08 Jun 2008 13:51:01 +0200
Message-ID: <>

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
>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 query.

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

Original text of this message