Re: impdp performance

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 24 Jun 2009 23:38:40 -0500
Message-ID: <effc058d0906242138k1ecb94c7v1254bb050d33996a_at_mail.gmail.com>



I was informed offline this:

"IIRC indexes were not created in parallel but only one worker thread creates them. this was logged as a bug/enhancement request. maybe be fixed in 11g."

Is this true?

On Mon, Jun 22, 2009 at 3:31 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> The alternative would presumably be to extract the ddl beforehand with
> dbms_metadata, you can then conditionally add parallel or not. Then run your
> script afterwards.
>
> On Mon, Jun 22, 2009 at 2:18 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
>> Thanks Yechiel, That is what I did last time. I wanted to check if there
>> was something new.
>>
>> It was not a little edit though. It was not just search and replace. The
>> index definitions of some indexes had parallel already built in them, which
>> caused them to fail after I added my own parallel clause. I guess I will do
>> it that way.
>>
>>
>>
>> On Mon, Jun 22, 2009 at 12:32 AM, Yechiel Adar <adar666_at_inter.net.il>wrote:
>>
>>> You can use impdp with:
>>> sqlfile=index.sql,include=index
>>> to get the sql to create all the indexes.
>>>
>>> A little edit will make all the create index no logging and parallel ans
>>> analyzed.
>>> You get additional bonus as you can then split the index creation to 3-4
>>> parts and run them in parallel.
>>>
>>> Adar Yechiel
>>> Rechovot, Israel
>>>
>>>
>>>
>>> Ram Raman wrote:
>>>
>>>> Hi all,
>>>> We have about 50,000 indexes in this schema. If I exclude indexes
>>>> during import and decide to create them later using Nologging and parallel
>>>> options, do I need to extract the index DDLs for each of the indexes and
>>>> modify the DDL for each of them or is there any quick way to set it for all
>>>> indexes. v 10g. I used a parallelism of 8.
>>>> Thanks.
>>>>
>>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 24 2009 - 23:38:40 CDT

Original text of this message