Oracle Database - Oracle MERGE Statement Slow Processing

Asked By Rajender Prasad on 16-May-18 11:18 AM

hi All,


I have a table name A in Oracle which is of almost 3TB data.


We have MERGE statement to update if records is existed and Insert if record not existed.


For every 15 days, I also get nearly 50 million records from another table say B.


for 50 million records, MERGE statement is taking more than 72hrs and if the process STUCK, I need to restart the MERGE and is going to take another 72hrs as we are not doing any commit here.


Table A & B are well partitioned.


Please suggest some best possible way to reduce the processing time.


Thank you


Regards,

Rajender