Home » RDBMS Server » Performance Tuning » Remote query performance in BO reports (Oracle 11g)
Remote query performance in BO reports [message #629726] Mon, 15 December 2014 12:19 Go to next message
lavk
Messages: 12
Registered: February 2010
Junior Member
Hi Experts,

We some history tables at remote database.We are accessing these history data in BO reports using view.
These history tables containing the 85 million records.And BO reports are taking too much time to fetch those records in reports.

Is there any way we can minimize the round-trip in network to fetch those records in our reports/local database?


Thanks,
Lav

Re: Remote query performance in BO reports [message #629727 is a reply to message #629726] Mon, 15 December 2014 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way we can minimize the round-trip in network to fetch those records in our reports/local database?
only return the records required in the report
Re: Remote query performance in BO reports [message #629820 is a reply to message #629727] Tue, 16 December 2014 05:08 Go to previous messageGo to next message
Flyby
Messages: 185
Registered: March 2011
Location: Belgium
Senior Member
a driving site hint?
Re: Remote query performance in BO reports [message #630009 is a reply to message #629820] Thu, 18 December 2014 09:47 Go to previous messageGo to next message
lavk
Messages: 12
Registered: February 2010
Junior Member
Hi,

Thanks for Your reply!!

I have used 'Driving_site' hint but it is not so much useful. I have checked the query with and without this hint, it is taking almost same time to complete the query.


Thanks,
Lav

Re: Remote query performance in BO reports [message #630010 is a reply to message #630009] Thu, 18 December 2014 09:48 Go to previous message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/
Previous Topic: tuning basics
Next Topic: Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR
Goto Forum:
  


Current Time: Tue Feb 20 20:32:11 CST 2018

Total time taken to generate the page: 0.05478 seconds