Oracle Distributed Systems

Name

DBMS_DEFER_SYS.PURGE (Oracle8 Only)

Synopsis

The PURGE procedure purges transactions that have been propagated from the deferred transaction queue.

FUNCTION DBMS_DEFER_SYS.PURGE(
   purge_method IN BINARY_INTEGER := purge_method_quick,
   rollback_segment IN VARCHAR2 := NULL,
   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,
   write_trace IN BOOLEAN := FALSE )
RETURN BINARY_INTEGER;

Parameters

Parameter Name	Description
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	If > 0, maximum number of seconds to spend executing transactions.
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 result in a trace file.

The return values for PURGE are listed in the following table:

Value	Meaning
0	Normal completion after delay_seconds expired
1	Terminated by lock timeout while starting
2	Terminated by exceeding execution_seconds
3	Terminated by exceeding transaction_count
4	Terminated at delivery_order_limit
5	Terminated after errors

Exceptions

Exception ...