This discussion is archived
1 Reply Latest reply: Jul 11, 2013 8:43 PM by scott.wesley RSS

Database link slows down the response time

Friend of Oracle Newbie
Currently Being Moderated

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

Legend

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