PARALLEL QUERY
- From: "DBA Deepak" <oracle.tutorials@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Oct 2007 12:19:59 +0530
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
Other related posts:
