Re: Can Parallel query run with dual core processor ?
Date: Sun, 08 Jun 2008 13:51:01 +0200
On Sun, 8 Jun 2008 01:10:43 -0700 (PDT), krislioe_at_gmail.com wrote:
>I am running Oracle 10g on Redhat Linux, on dual core single
>Can I run parallel query in it ?
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 DBAReceived on Sun Jun 08 2008 - 06:51:01 CDT