Tuning to Insert and Update Massive.

Hi there.

I need to insert and update 1 million data in an optimal time. I use a cursor for the WHERE clause of the INSERT and UPDATE. I use / * APPEND * / for the INSERT, and for the UPDATE I use / * + PARALLEL (table_name) * /.

However the process takes 10 hours to finish.

Note: I am running on Oracle 12.1.0.2.0

I remain attentive to your comments and suggestions.

Thanks and greetings.