1 Reply Latest reply: Jul 11, 2013 10:43 PM by scott.wesley RSS

    Database link slows down the response time

    Friend of Oracle

      Hello All,

       

      I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint

      and it worked when executed from sql*plus or pl/sql developer. It returns results in 3 seconds or even less. However, when

      i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins! I'm wondering

      if you have some inputs on how to resolve, analyze this issue.

       

      Thanks.

       

      Greg