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

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 3 Aug 2004 13:41:27 -0400
Message-ID: <BAY9-DAV15RnfN0Rgcr0000ce0c@hotmail.com>

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_at_mail.ee> To: <oracle-l_at_freelists.org>
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 12:39:12 CDT