Re: Huge Table Insert - take long time?

Also, just a thought:

For the duration of this load, disable FORCE LOGGING, then re-enable it when load completes, and catch up the standby with an RMAN Incremental backup?

-Mark

On Thu, Jul 26, 2018 at 10:30 AM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Hi Woody,
>
> Yes it does avoid UNDO, because it extends the table above the high-water
> mark and inserts the data into empty blocks. Empty block do not contain any
> information that would need to be saved in the UNDO segments. That is the
> principal benefit of doing /*+ APPEND */. You may want to try using
> DBMS_PARALLEL_EXECUTE instead of the /*+ PARALLEL */ hint. My experiences
> with DBMS_PARALLEL_EXECUTE are quite good.
>
> Regards
>
>
>
> On 07/23/2018 08:32 PM, Woody McKay wrote:
>
>>
>> Didn't realize that about APPEND avoiding undo even if FORCE LOGGING.
>> Thanks
>>
>>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l