Oracle Distributed Systems

Name

DBMS_DEFER_SYS.SCHEDULE_PURGE (Oracle8 Only)

Synopsis

The SCHEDULE_PURGE procedure schedules the automatic purge of transactions that have been propagated from the queue.

PROCEDURE DBMS_DEFER_SYS.SCHEDULE_PURGE(
   interval IN VARCHAR2,
   next_date IN DATE,
   reset IN BOOLEAN := FALSE,
   purge_method IN BINARY_INTEGER := NULL,
   rollback_segment IN VARCHAR2 := NULL,
   startup_seconds IN BINARY_INTEGER := NULL,
   execution_seconds IN BINARY_INTEGER := NULL,
   delay_seconds IN BINARY_INTEGER := NULL,
   transaction_count IN BINARY_INTEGER := NULL,
   write_trace IN BOOLEAN := NULL );

Parameters

Parameter Name	Description
interval	Frequency with which to execute the call.
next_date	First time to execute the purge.
reset	If TRUE, last_txn_count, last_error, and last_msg are nulled in DEFSCHEDULE data dictionary view.
purge_method	1 = purge_method_quick (not necessarily complete, but faster). 2 = purge_method_precise (complete purge).
rollback_segment	Which rollback segment should be used.
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	If > 0, routine sleeps for this many seconds before resuming when there are no more transactions to push to destination.
transaction_count	Maximum number of transactions to push per execution.
write_trace	If TRUE, record the result in a trace file.