Problem: You have configured DA agent to perform external sort, but the database is still performing the sort operation.
Possible cause: 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 is, by default, 10 million.
Solution: Decrease the external_sort_activate_size to a value less than the number of rows in the source and target tables.