You may know that pulling data over a database link is serial, which is a great opportunity to take advantage of DBMS_PARALLEL_EXECUTE.

Here’s an example of how to pull something over a database link in parallel.