Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5 "10046" Tracing ...)

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 3 Aug 2004 13:41:27 -0400

Well now I can go home because I've learned something today. Never looked at
degree in dba_indexes. I create all of my indexes in parallel which I guess
automatically puts as degree = 'DEFAULT'. I have only seen this effect on my
partitioned tables. This is good, time for some serious testing.

Thanks
Mike
----- Original Message -----
From: "Tanel Põder" <tanel.poder.003@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, August 03, 2004 1:16 PM
Subject: Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5
"10046" Tracing ...)


> > the query will serialize. If I put a local bitmap index on jack and the
> > partitioned key is not specified in the query then a parallel index
probe
> > into each local index.
>
> Are you sure that your partitioned local index is also PARALLEL 1?
>
> Tanel.
>-----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: