1. Developing SOA Applications with Oracle SOA Suite
  2. Using the Oracle Mediator Service Component
  3. Resequencing in Oracle Mediator
  4. Resequencing Order
  5. Best Effort Resequencer
  6. Best Effort Resequencer Message Selection Strategies
  7. Maximum Rows Selected

Maximum Rows Selected

When the best effort resequencer is configured to use a maximum number of rows, it performs the following steps whenever new messages are available in the resequencer database:

  1. The resequencer orders the messages according to the specified sequence ID (typically a date and time stamp).

  2. The resequencer locks and selects the number of messages equal to the value of the maxRowsRetrieved parameter from the ordered messages above.

  3. The resequencer processes the selected messages one after another in its own transaction in sequence.