SQL over db link is performing exremely slow

SQL-TEXT

-----------------------

SELECT  calendar_code

        , description

        , days_on

        , days_off

        , calendar_start_date

        , calendar_end_date

        , 1

        , '''||p_instance_code||'''

        , '||v_add_delete_flag||'

        , SYSDATE

        , NULL

        , SYSDATE

        , '||g_user_id||'

        , '||g_login_id||'

        , '||g_conc_request_id||'

        , '||g_prog_appl_id||'

        , '||g_conc_program_id||'

        , sysdate

        , 1

        , NULL -- ''N''

        , 1   -- 7

  from ASCP_USER.OI_EB_CLNDRS_VW@dblink;

View ASCP_USER.OI_EB_CLNDRS_VW sql text

----------------------------------------------------------------------

SELECT SUBSTR(a.business_unit,   3) || '|' || a.calendar_code_pr AS

calendar_code,

  b.descr AS

description,

  7 AS