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:
| |||
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 ... |
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.