Insert using /*+ append */ hint not reduced my time

[John Spencer]

You might try changing the first SELECT in your query to use the DRIVING_SITE hint. So, it should look something like:

SELECT /*+ DRIVING_SITE (remotetablename) */
       columnnames
FROM remotetablename@dblinkname

If you are aliasing remotetablename, then you will need to use the alias instead of remotetablename in the hint.

TTFN
John