PARALLEL QUERY

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Tue, 16 Oct 2007 12:19:59 +0530
Message-ID: <75aa80160710152349j33f9b951hf39c264a8406d7ce@mail.gmail.com>

Hi Experts,

Have a problem related to parallel query execution. I have a setup of Oracle 10g (10.2.0.3) on solaris 64 bit and on a 16 core CPU system.

When I execute parallel hint in the query the following happens.

Does not use PQ processes for the query:

select /*+ parallel(bt,4) */ from big_table bt;

Does use PQ processes for the query:
select /*+ parallel(bt,16) */ from big_table bt; Please help me in understanding why this happens.

--

Regards,

Deepak
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 16 2007 - 01:49:59 CDT