Re: Huge Table Insert - take long time?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 26 Jul 2018 10:30:31 -0400
Message-ID: <8dc7abd9-f8da-9f76-5a1b-17bccc7f6314_at_gmail.com>
Date: Thu, 26 Jul 2018 10:30:31 -0400
Message-ID: <8dc7abd9-f8da-9f76-5a1b-17bccc7f6314_at_gmail.com>
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
Received on Thu Jul 26 2018 - 16:30:31 CEST