This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Nov 21, 2013 9:01 PM by GelnYang RSS

Slow Performance with DBLink

GelnYang Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points