interval
|
Allows you to provide a function to calculate the next time to purge. This value is stored in the interval field of the DEFSCHEDULE view and calculates the next_date field of this view. If you use the default value for this parameter, NULL , then the value of this field remains unchanged. If the field had no previous value, it is created with a value of NULL . If you do not supply a value for this field, you must supply a value for next_date . |
next_date
|
Allows you to specify a time to purge pushed transactions from the site's queue. This value is stored in the next_date field of the DEFSCHEDULE view. If you use the default value for this parameter, NULL , then the value of this field remains unchanged. If this field had no previous value, it is created with a value of NULL . If you do not supply a value for this field, then you must supply a value for interval . |
reset
|
Set to TRUE to reset LAST_TXN_COUNT , LAST_ERROR , and LAST_MSG to NULL . |
purge_method
|
Controls how to purge the deferred transaction queue: purge_method_quick costs less, while purge_method_precise offers better precision. |
rollback_segment
|
Name of rollback segment to use for the purge, or NULL for default. |
startup_seconds
|
Maximum number of seconds to wait for a previous purge of the same deferred transaction queue. |
execution_seconds
|
If >0, then stop purge cleanly after the specified number of seconds of real time. |
delay_seconds
|
Stop purge cleanly after the deferred transaction queue has no transactions to purge for delay_seconds . |
transaction_count
|
If > 0, then shut down cleanly after purging transaction_count number of transactions. |
write_trace
|
When set to TRUE , Oracle records the result value returned by the PURGE function in the server's trace file. |