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