This section contains several examples of distributed transaction processing.
In the first example, the DML statement queries a remote object. The DML operation is executed serially without notification because it references a remote object.
INSERT /*+ APPEND PARALLEL (t3,2) */ INTO t3 SELECT * FROM t4@dblink;
In the next example, the DML operation is applied to a remote object. The
DELETE operation is not parallelized because it references a remote object.
DELETE /*+ PARALLEL (t1, 2) */ FROM t1@dblink;
In the last example, the DML operation is in a distributed transaction. The
DELETE operation is not executed in parallel because it occurs in a distributed transaction (which is started by the
SELECT * FROM t1@dblink; DELETE /*+ PARALLEL (t2,2) */ FROM t2; COMMIT;