External Sort Option Configuration

Problem: You have configured DA agent to perform external sort, but the database is still performing the sort operation.

The enable sort option is not activated because the number of rows in the table is less than the external_sort_activate_size value, which by default is 10 million.

Solution: Decrease the external_sort_activate_size to a value less than the number of rows in the source and target tables.

Related tasks
Configuring Data Assurance Server Parameters