1 Reply Latest reply on Jul 12, 2013 3:43 AM by swesley_perth

    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.