Mediator Re-sequencer purging
Earlier Mediator Re-sequencer tables were not considered for purging from purge scripts. We have included this from 11g Patch-set 5 onwards and did a back-port on the previous patches also
Purge scripts now considered below table while executing loop/parallel purge
1. MEDIATOR_GROUP_STATUS
2. MEDIATOR_RESEQUENCER_MESSAGE
There are couple constraints in executing purge on mediator re-sequencer tables
MEDIATOR_GROUP_STATUS
What can be purged
1. FOR BestEffort and FIFO groups in READY state,
2. We try to purge messages first and then the groups.This facilitate group purging.
What cannot be purged
1. Standard Mode Re-sequencer groups cannot be purged.
2. groups in running state cannot be purged(for all the strategy)
MEDIATOR_RESEQUENCER_MESSAGE.
1. Messages in COMPLETED and ABORTED state only can be purged. Rest all cannot be purged.
what are the different status available under above tables
Group states:
READY = 0; ->Purgeable
LOCKED = 1; ->NON Purgeable
ERROR = 3; ->NON Purgeable
TIMED_OUT=4; ->NON Purgeable
GROUP_ERROR=6; ->NON Purgeable
message states
READY = 0; ->Purgeable
LOCKED = 1; ->NON Purgeable
ERROR = 3; ->NON Purgeable
COMPLETED = 2; ->Purgeable
TIMED_OUT=4; ->Purgeable
ABORTED=5; ->Purgeable
Loop and parallel same scripts can be used from my old blog Executing Parallel Purge script andExecuting Loop Purge scrip
