Question on tunning while INSERT SELECT
Hi,
As part of my new requirement, I need to load 360 million records using INSERT SELECT with append mode as single transaction and COMMIT once completed.
I have been asked not to use partition swap, because data will be lost if the partition swap fails. And not allowed to include NOLOGGING as the database would be in ARCHIEVE mode.
I need your expert brains. I need your help to speed up the performance of the INSERT SELECT.
Technology: PLSQL
Oracle Version: 11G R2
Server: M5000 + 400 GB Flash
Note: As of now, we do not have a 11g environment.
Many thanks in advance.
Regards,