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