1 2 Previous Next 16 Replies Latest reply: Nov 21, 2013 11:01 PM by GelnYang RSS

    Slow Performance with DBLink

    GelnYang

      Hi,

       

      The select blow is fast:

      SELECT COUNT(1)  FROM STORE_CLIENTS@OLDVTSDBLink   WHERE STORE_NO = '2'  AND CLIENT_NO = '381725';

       

      But the following script is very slow and will cause time-out exception:

       

      DECLARE

      COUNT_TEMP NUMBER(6,0);

      BEGIN

        SELECT COUNT(1)  INTO COUNT_TEMP  FROM STORE_CLIENTS@OLDVTSDBLink   WHERE STORE_NO = '2'  AND CLIENT_NO = '381725';

      END;

       

      I have tried the driving_site hint , but didn't work. It maybe a compling problem,but I have no idea how to find valuable information.

      Any sugguestion would be appreciate!

       

      Eric

        1 2 Previous Next