Oracle Distributed Systems

Name

DBMS_DEFER_SYS.PUSH

Synopsis

The PUSH function pushes a queued transaction to a destination node.

FUNCTION DBMS_DEFER_SYS.PUSH(
   destination IN VARCHAR2,
   parallelism IN BINARY_INTEGER := 0,
   heap_size IN BINARY_INTEGER := 0,
   stop_on_error IN BOOLEAN := FALSE,
   write_trace IN BOOLEAN := FALSE,
   startup_seconds IN BINARY_INTEGER := 0,
   execution_seconds IN BINARY_INTEGER := seconds_infinity,
   delay_seconds IN BINARY_INTEGER := 0,
   transaction_count IN BINARY_INTEGER := transactions_infinity,
   delivery_order_limit IN NUMBER := delivery_order_infinity )
   RETURN BINARY_INTEGER;

Parameters

Parameter Name	Description
destination	Global name of the destination database.
parallelism	Degree of parallelism: 0 = serial (no parallelism) 1 = parallel propagation with one slave n = parallel propagation with n slaves
heap_size	If > 0, maximum number of transactions to examine simultaneously for parallel scheduling computation. If 0, compute this number based on parallelism parameter.
stop_on_error	If TRUE, then stop on the first error, even if not fatal.
write_trace	If TRUE, record result in a trace file.
startup_seconds	Maximum number of seconds to wait for the completion of a previous push to the same destination.
execution_seconds	Maximum number of seconds to spend on the push before shutting down; defaults to seconds_infinity (i.e., unlimited).
delay_seconds	Shut down push cleanly if queue is empty for this many seconds.
transaction_count	Maximum number of transactions to push per execution.
delivery_order_limit	delivery_order ...