Name
DBMS_DEFER_SYS.EXCLUDE_PUSH (Oracle8 Only)
Synopsis
Oracle8 uses a slightly different mechanism to propagate transactions to remote databases. Instead of deleting transactions from the local queue as soon as they are delivered to a remote site, Oracle purges the queue as a separate process. This strategy enhances performance because there is no need for a two-phase commit when transactions are propagated. In addition, Oracle8 includes support for parallel propagation, which means that multiple transactions can be delivered to the destinations simultaneously if they are not dependent on each other.
FUNCTION DBMS_DEFER_SYS.EXCLUDE_PUSH (timeout IN INTEGER) RETURN INTEGER;
timeout is the time to wait to acquire a lock that disables pushes. Specify DBMS_LOCK.MAXWAIT to wait indefinitely.
The EXCLUDE_PUSH function may return the values shown in the following table:
Value | Meaning |
|---|---|
0 | Normal successful completion |
1 | Timed out waiting for lock |
2 | Unsuccessful due to deadlock |
4 | Lock is already owned |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
