Start In parallel with updating

In parallel with updating

The restriction will be removed automatically once this activity stops.

UPDATE dest_tab tt SET (tt.code, tt.description) = (SELECT st.code, st.description FROM source_tab st WHERE = tt.id) WHERE EXISTS (SELECT 1 FROM source_tab WHERE id = tt.id); 5000 rows updated.

SQL ----------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------- | 0 | UPDATE STATEMENT | | 4999 | 185K| 30013 (34)| | | 1 | UPDATE | dest_tab | | | | | | 2 | NESTED LOOPS SEMI | | 4999 | 185K| 19 (6)| | | 3 | TABLE ACCESS FULL | dest_tab | 10000 | 332K| 18 (0)| | |* 4 | INDEX UNIQUE SCAN | source_tab_PK | 2500 | 10000 | 0 (0)| | | 5 | TABLE ACCESS BY INDEX ROWID| source_tab | 1 | 43 | 2 (0)| | |* 6 | INDEX UNIQUE SCAN | source_tab_PK | 1 | | 1 (0)| | ----------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("ID"="TT"."ID") 6 - access("ST"."ID"=: B1) UPDATE (SELECT tt.id, tt.code, tt.description, AS st_code, st.description AS st_description FROM dest_tab tt, source_tab st WHERE = st.id) ilv SET = ilv.st_code, ilv.description = ilv.st_description; 5000 rows updated.

This page provides links to the current Release Notes for the Intel® Parallel Studio XE Cluster, Professional, and Composer Editions.

Upgrading is simple, but does require a few tweaks.

Each lock would get its own identifier, so none of he locks would keep any other thread out.

To make the lock work at all, you need to use the same identifier for all locks.

Note: You need to upgrade the global package to use v4, but v3 will still work for each local project where needed.