Commit;
The Update table_A set tel='1234' where tel is not null;
Commit;
Update table_B set mail='123 @ com' where the mail is not null;
Commit;
The Update table_B set fax='123-123 where fax is not null;
Commit;
.
Enumerated above two tables more xinwen, similar xinwen and thousands of lines, more want to improve the execution speed, before the execution of the three files, approximately three thousand update, need to 14 hours.
Some people say that execute in parallel, but didn't read it after checked, the parallel way,
Which man would, according to the example above write let me as a reference,
Grateful!
CodePudding user response:
Article 3 k record 14 hours? How can so slowly, this relation with parallel nothing,In the process of statement execution, the select * from v $session_wait, see what's waiting for the event